>All the data is in MySQL. To use views I would have to create a "dummy" VFP database with views. MySQL, however, only seems to work well using SPT.
>

Well 'dummy' if you want to call it that. But yes, you would set up a database that would only contain your Remote Views and the connection to your MySQL database.

BTW: I can't see why things would work with SPT and not remote views. All remote views are is a 'Simplified' SPT, where you let VFP do alot of the SQL work for you!

>Manually means creating a huge SQL statement converting all the fields to strings for the SQL UPDATE.

Basically, yes, with SPT to update the database, you are create UPDATE statements and 'passing' them to MySql.. correct?


>>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.
>>
>I certainly would be interested. I suppose there's no chance of the VFPSQL Server being available on Unix/Linux?

Since it will be a VFP EXE not really, unless you could get it to run under WINE or WABI or other Windows emulator, but that would basically defeat the purpose. It will most likely require MTS for pooling, but I haven't definatly decided on that yet.

BOb