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...

Thank You!

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: Problem sorted. My solution involves creating a button that, when clicked, deletes all open records in the bank (where open is any record that has not been agreed to the actual bank balance), then duplicates the last record in the remaining records. Then increment the date, set the opBal to...

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...

Thanks to you both. I think I have sorted it by firstly joining order to order then creating a second link, not mattering to what.Amending the properties so as to make line join to line works. I got a message saying "remakes is not an object" which I studiously ignored and it works fine. Thanks...

Thanks, Mike. however maybe I am missing something here because it is still not working. I have definitely got identical fields in each table; order and line. They are of the same type. I have created a compound key STR(order)+STR(line). This is a primary key in the orders table but a regular...

Thanks, Mike - that was prompt! Yes, I think I am using compound keys - I used the expression builder thus: Str(Order 19,2)+ Str(Line 19,2) The same for each table. I have just tried writing a query, joining order and line from each table....and get the same problem! I can join order to order. I...

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...

Got it! (Well, got it off the internet..thanks to Joseph A. Huwaldt) This code takes a specified file (plbacs.csv) and converts it to something windows can read try { File inFile = new File("c:\\Waverly\\plbacs.csv")...

Hi sedj: It is a csv file created from a windows based accounting system. It is a list of payees and their bank details. My utility reads the file (written in JBuilder it uses JDatastore) as a grid, allowing me to delete accounts I do not want to pay. The process of saving the file creates...

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...

Olaf: Thanks for that. You are right. They are sales orders that come in; and every month I reconcile these to the accounts database by deleting and reappending all records for the month just ended. I warned you I was a novice! In fact the main reason I am looking at VFP is Rushmore; I am...

Thank you very much, Geoff. Does this, however, mean I am misunderstanding SQL? THe Oracle table has over 750000 records and I thought that an incremental append would speed things up, by only selecting those after a certain number. The subquery will trawl through all 750000 records, I...

Thanks to you both for this advice: I am sorry it was what I call a 'lazy' question - the proper answer should have been RTFM! I want to use VFP to replace Paradox as a Data Warehouse, pulling large amounts of data from an Oracle database. I wrote an 'incremental' append query in Paradox where...

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...