Search results for query: *

Hi there: One reason for me buying VFP pro was that I believed that I could write stand alone applications. I believe that this should save our company a bundle of cash - no longer should every desktop have a copy of Access/Paradox/Approach (Yes I use all 3!); we can unify under the VFP flag...

Hi there: I have created an orders database, with a header and detail table. An entry form has the details as a grid. A third table is products. The cunning plan is to allow the user , when entering a detail line, to select from a drop down list in the grid an item from the products table. Now I...

Hi: Running VFP8 I am trying to write an ordering system. What I want is the order detail to have a unique and ascending line number - that resets for each order. So order 1234 can have lines 1,2,3 So order 1235 can have lines 1,2,3 - not 4, 5, 6 which AutoInc will do! In other words can I reset...

Here is a question from somebody who wants to learn about Delphi.. I have written a program in Java that deletes files from a pre specified directory (ie click the button and all files beginning with "0" in a certain directory are deleted); I use it at work to clear some directories regularily...

Hi there: Here at work we have 2 bank accounts and transfer from one to another. I have written a nice database which tracks the movements with a synchronising query (changeto)that copies the transfer from one account to another, ON THE SAME DAY. However in real life the transfer takes 3 days. I...

Hi There: Here is a problem that has vexed me - I want to create a bank account type database. I have a table for payments, a table for receipts, and a table for the date, called Bank. Using repeating panels off the bank database for payments and receipts I can create summaries of payments and...

Hi there: I am a bit flummoxed with VFP forms at present. I have a 'remakes' table with an order number and line as primary key. I have an 'orders' table with an order number and line as primary key. I want to create a form based on the remakes table such that, when entering the order number and...

Hello there: I have written my first Java utility which looks at a csv file of payment instructions, makes changes if I want, and saves it. The problem is that the changed file cannot be read by the bank program- opened in notepad the end of lines appear all wrong. I have looked through your...

Hi there: I am new to VFP - VFP 8 in this instance - and am looking for a delete query and append query feature in the query designer...but cannot. Do these queries have to be written in SQL or does the designer allow me to do this? Thanks!

Hi there: I am trying to write an app that identifies files in a specific directory over a week old, then deleting them. However, I am even stuck on the first part - the File class. Am I right that the following should return a list of all files in the directory "B2delete"? public static void...

Hi guys: here is a puzzler: I am importing a text file for units. Every line represents a unit, so I can have 10 identical lines, each with a unit of 1. Is there any way of converting these 10 lines of 1 unit to a single line, quantity 10? A line has over 15 fields but I may be able to reduce...

Hi there: I was so proud of myself, writing my first Java utility which reads a text file of payments using a jdb table format so that the user can delete "records" (lines of the file) easily and readily and then save the amanded file. However..the original csv file, when saved (even if not...

Hi there: I have just acquired VFP 8 and have a slight problem. If modify a table, then come come out of it and run a form against it I get a message "error: table in use. The table may already be opened exclusively" The only way to get things going again is to come out of VFP. I have checked...

A big dumbo question... I have written in JBuilder a nice little text utility. However, how do I create this as a stand alone application to run on another pC? What files should I use? I have tried the Native Executable but the 2 .exe files created simply do not run. It does not even work on my...

Hi there: I use Paradox, Access, Approach etc to read Oracle tables and views;I have heard about VFP and have just got my hands on an old copy of VFP3 with a view to buying the latest version. However, I get an error when I try to read an Oracle view. Tables are fine so ODBC is ticking over...

Hi there: We are new to Lotus Notes and will be getting 6.5 soon. However we are trying to get our heads round the thing and want to know what is the relationship between Notes and Organiser? Should we get both? Or does Notes do everything (and more) Organiser does? Basically, where does...

Hi there: I have managed to use ActiveX to open a crystal report from Access. However, the report does not refresh itself - and there is no refresh facility in the Crystal viewer. Does anybody know how to either get crystal to refresh itself on opening -to give the up to date data - or have a...

Hi there, can anybody please advise on how to sort an Access table that exports as a text file in the sorted order? We cannot use primary key to define the table sort order and therefore need an alternative. Thanks in advance

Hello There: I have an XML file that I am trying to convert to a database format. I have played about with an XSLT but cannot find an instruction for 'end of record'. THe XML is a series of purchase orders so I need to separately define each order. I am initially looking to convert to text but...

Hi guys You have already helped a great deal with a map I am writing...one more question? I want to overlay the map with shaded areas denoting certain demographic differences. Like a real map may have an overlay for high crime rates , rainfall, education, population density etc. I am thinking...