For the last 10 years, first w VFP7 and the last 4 years w VFP9 in a network w 20 computers, i have been using VFP'sDBC and parametrized remote views. The parametrized View is created on the fly locally and removed when the form goes out of scope.
Every trouble that appeared were do to network bad functioning. E. >Definitely. > >I have been using a combination of remote view and SQLPassthrough 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 SQLPassthrough. >-------------------- > >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/1319041811.66809.yahoomail...@web160805.mail.bf1.yahoo.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.
