On 10/18/11 5:59 PM, Rick Schummer wrote: >>> 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.
It's been a long time since I've dealt with SQL Passthrough versus Remote Views in VFP, so I won't argue very hard. Things may have changed for the better after VFP8, or perhaps I was never doing it right, but I tried to get remote views working reliably before switching to SQL passthrough, and I got pretty far but the DBC would eventually get corrupt with remote views, and parameterized remote views couldn't be shared among multiple users because of 'view definition has been changed'. SQL Passthrough, for me at least, was much simpler to implement and deal with in the end, and completely reliable. I could build my own local parameterized views in code (local DBC for each user), make them updatable, and have the best of all worlds. Paul _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
