General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Trapping Error 1709
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only