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