Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection & Remote Views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00235859
Message ID:
00235885
Vues:
29
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform