>> YMMV<< Definitely.
I have been using a combination of remote view and SQL Passthrough for the last 16 years with much success. The problem with networking a DBC with remote views is not a problem when you copy it locally, or compile it in the EXE. The networking issue by the way is when VFP temporarily locks the DBC when it opens a remote view to get a frozen copy of the view definition. We solved this by copying the remote view DBC to a local temp folder. Never a problem after that. Solved more than a decade ago. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, October 19, 2011 09:34 To: profoxt...@leafe.com Subject: Re: VFP 2 MySql 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 [excessive quoting removed by server] _______________________________________________ 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/001601cc8e77$2a8f0450$7fad0cf0$@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.
