>>you have to make a connection to an ODBC database and have scripts (select statements) to pull data back to VFP. You

will also need update and insert scripts as well to save data.<<

Not always true. Once you establish a connection you can make remote views. With remote views you USE to open the

cursor, and to update and insert all you need is APPEND BLANK and REPLACE, with a common TABLEUPDATE(). VFP builds all

the code to do the update in MySQL behind the scenes. Similar with CursorAdapters.

Not everyone lives in the world of SQL Passthrough.

And don't even think about pulling out some performance non-sense. It might have been true in the 1990s, but for

standard CRUD operations a lot of the time they are so close humans cannot tell the difference.

Rick

White Light Computing, Inc.

www.whitelightcomputing.com

www.swfox.net

www.rickschummer.com

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/000e01cc8dfa$57c57300$07505900$@whitelightcomputing.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.