Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote views
Message
 
À
31/03/2000 16:40:59
Steve Summers
Pima County Superior Court
Tucson, Arizona, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00353645
Message ID:
00353828
Vues:
19
Steve,
I just solved that one! VFP sends off the Remote View command and then goes on to the next command without waiting for the command (use, TableUpdate() etc.) to complete. That may not be the actual fact, but it sure seems to be the 'appearance'. If another view tries to use the same connection, it's error 1541. I just trap for it and repeat the command. How many times (and what the wait between tries is) depends on the circumstances. Works fine. I'm planning to write it into my error handler so I can have a variable that will control the number of retries before I have to exit.

HTH
Barbara

>I'm working on converting data from a VFP Database to an Informix Database. I'm getting FOX ERROR 1541 "Connection is busy" during my =tableupdate(.t.,.t.) command on my remote views. This results in the transaction being rolled back. Does any one know why this happening?
>
>Should my views be sharing a connection or should I have a connection for each view? Should the connection be asynchronous?
>
>Thanks in advance.
>
>Steven Summers
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform