Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verifying if a table is open exclusive
Message
De
22/09/1999 17:31:23
 
 
À
22/09/1999 16:50:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00267791
Message ID:
00267809
Vues:
21
>Hi Martineau,
>
>>I have to open a table exclusive how can i verify if the table is not open by the other application.
>>Use Table In 0 Exlusive
>>a message box tel me that the table is use
>
>Do this:
>
>
lcError = on('error')
>on error *
>
>use .. excl
>
>on error &lcError
Now USED('table') will tell you if you were succesful or not. If this seems cumbersome, try to make it a reusable method.

Just to explain this idea a bit. The only way to make sure you get exclusive use of a table is to try to USE EXCLUSIVE and then have the error handler fire if you can't get it or do as Mike suggested.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform