Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trapping Error 1709
Message
From
28/09/1999 08:42:43
 
 
To
27/09/1999 22:37:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00269767
Message ID:
00269862
Views:
18
>Our foundation uses an error trapping routine (ala TRO) to open views. This methodology allows us to always 'select' rather than testing to see if the view we want is already open. Works well except when two users attempt to open the same view simultaneously. That results in another error (1709 Database Object is In Use by Someone Else ).
>
>The obvious solution is to trap that error and retry but it is apparently not possible to nest error routines. Any suggestions? (other than rewriting our foundation <s>)
>
>Thanks, Ken

You can't nest them, but you can issue an ON ERROR * inside your error routine. Yu can then subsequently check to see if the view opened.

BTW, how do oyu use an error routine to open views?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform