>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