Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote views
Message
 
To
31/03/2000 16:40:59
Steve Summers
Pima County Superior Court
Tucson, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00353645
Message ID:
00353828
Views:
18
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform