I use sqlstringconnect() passing in a connection string, (which I store in an INI file) to get a connection,
then sqlprepare to make sure the sql command is valid, and I still have a conneciton.
then issue the sql command, and get the results. (read write local vfp cursor)
the sqldisconnect. to free up the processing on the MySql server.

Thats the basics.

for my files - prg,s utilities here is where I post them.
http://www.1amsoftware.com/~mysqlvfp/

Get the file my.prg (its a proceedure file with a few utilities, like new record, save record and so on.

For a more complete discussion on the process, I have posted some notes for the past few months, over on Yahoo, at

http://groups.yahoo.com/group/VFPMySql Join the group, and read up on how its all puts together. Quite a few good links about how to convert data, making connection strings, and so on.

a few notes before you start following,
1 I dont use remote views,
2 I dont use a dbc.
Everthing I have done, is based on SPT making VFP local cursors only. Once you have a VFP cursor you then can use skip, replace, whatever normally would, but
Then once you have changed your local cursor, the process of saving is one record at a time, using the class mysave ()

Yhe process is not as robust as using remote views, but it does allow me to control what is going on with my data. Feel free to comment on, and improve the code as required.

Bob Lee



>Very impressives result, could you give some code about the connexion you use between MySQL and VFP ?
>
>Does any body here do some assistant which change automaticcaly code (like USE SKIP...) to enhance a VFP project with MySQL capabilities ?
>
>Best Regards