Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection & Remote Views
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00235859
Message ID:
00235885
Views:
28
>Is there a mechanism to re-establish the connection used in a Remote View if for some reason I lost it?
>
>use myremoteview
>? cursorsetprop( 'connecthandle' ) && 3
>
>* ...
>* do some process here
>* (for some reason I lost my connection)
>* ...
>
>
>* Here I know that my connection is not longer
>* valid. How can I re-establish it and bound it
>* to the remote view (actually to the cursor)
>* before I do a tableupdate() ?

You may be out of luck unless you can use SQLExec() to create a connection that returns a connect handle equal to the one in the voew you opened. If you are losing the connection while the view is still open, you are having problems beyond VFP. Do you know why you are losing this connection? I some other piece of VFP code closing this connection? In your Tools/Options/Remote Data, do you default views to Share Connection? When you create SQL View programmatically, do you specify the view to use a shared connection?
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform