Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement