Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1709: Database object is being used by someone els
Message
De
25/02/1999 10:29:27
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00191088
Message ID:
00191426
Vues:
38
>Opening forms simultaneously causes problems for me too - easily reproduced by opening the form twice. I get error 2005, but the symptoms are the same.
>
>I solved it by embedding the DO FORM inside a retry loop along the lines of:-
>
>
>* preserve the old error handler.
>oldEHandler = on("Error")
>
>* you should really preserve the reprocess too
>set reprocess to 2 seconds
>
>* retry counter...
>nRetries = 0
>
>* ...and maximum - you may want this tweakable by your program, so
>* DON'T use a constant
>nMaxRetries = 6
>
>* set the error code...
>e = 0
>
>*...and force the random number generator to seed (see help)...
>=rand(-1)
>
>* Here we go:-
>on error e = error()
>do form (fName) NAME .....etc
>do while (e <> 0) and (nRetries < nMaxRetries)
>  * you might want a 'working...' message in here...
>  nRetries = nRetries + 1
>  * delay for a while...
>  =inkey(.2+rand())
>  e = 0
>  do form (fName) NAME .....etc
>enddo
>
>* restore the old error handler...
>on error &oldEHandler
>
>
>
>This works fairly well, although you will need to tweak it for your particular network (or if you want to get flashy, get it to tweak itself). I find it best to put in a 'retrying (n) of (m)' message to keep users occupied.
>
>Hope this helps.


Excellent suggestions, All. Thanks for your help.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform