Stephen Russell wrote: > On Feb 4, 2008 9:31 AM, MB Software Solutions < > [EMAIL PROTECTED]> wrote: > >> What's the best practice in this? iirc, Paul McNett does a timer >> process in the background where he constantly keeps polling something >> like "show tables" in order to keep the connection alive. I was doing >> this for getting my handle (and thus the goal was to re-establish >> connection if the simple command failed): >> > > Learn to live in the disconnected world? All I see is a force to attempt to > ride a former connection. Why not close them and > reopen? KISS. Reason is that when doing Web based stuff you won't try to > force the concept of an open pipe back to your data.
VFP's SPT cursors can't deal with being disconnected. They need to know they can communicate back to the server over the same handles it used before. This is a miserable failing of VFP, another case where they got something mostly right, but didn't bring it the last mile and gave us no way around it, except for reimplementing everything that SPT cursors bring to the table ourselves. The timer is the best compromise. Paul -- http://paulmcnett.com _______________________________________________ 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.
