>Hi, we are in the midst of re-developing certain VFP projects to use the MySQL database. The main reason for this is the atrocious speed problems that pure VFP has over WAN (Dialup and ISDN) connections. The other reasons for MySQL include the price of M$ SQL Server and it's non existant Unix version.
>We have a design problem that needs to be clarified now before any major programming takes place. The problem lies in updating tables via SQL. When updating a few fields the obvious choice is the SQL UPDATE command. When updating nearly all the fields (more than 20 fields) of a table, it seems that the quickest method of updating is to SQL DELETE the original record and use the MySQL LOAD DATA command to insert the new values from a text file. The text file is created by COPYing the updateable VFP cursor to it.
>Is there a better way? What are other VFP/MySQL developers using to update the MySQL tables from VFP?
>
>All suggestions are welcome.

Are you using views? If so you can set the update to use SQL DELETE than SQL INSERT instead of SQL UPDATE !!

If using SPT you can do the same manually.

BTW: Have you looked at an automation server to process the SQL. I am actually working on a generic VFPSQLServer that will be an automation server. If you are interested I will be looking for beta-testers/advisors soon.

BOb