>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