On Tue, Oct 18, 2011 at 7:59 PM, Rick Schummer <pro...@whitelightcomputing.com> 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. --------------------
With the unreliability of the dbc I think you may be playing with fire. I have had a difficult time with ver 7 dbc in a networking environment. When I go straight against the rdbms I have no real problem. If new drive letters appear at the site no issues to my working code. Move the home of the dbc and you are screwed from my recent experience. YMMV -- Stephen Russell 901.246-0159 cell _______________________________________________ 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/CAJidMYJfOkgJzp7SB9pb57f0e37F+yCbng_=dJmadY0XYTGT=a...@mail.gmail.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.
