Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use EXCLUSIVE opens the table READ ONLY!!!!!!
Message
 
 
À
19/02/1999 15:15:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00189463
Message ID:
00189510
Vues:
9
>I'm running in a multi-user environment on an NT server. Once in a while, I try to use the ID table exclusive and it opens, but I error out when I try to change the field value because the table is Read-only.
>
>Anybody have any ideas on how to force NT to only let one user at a time have access?

I never open a table exclusively except for pack and index. What I will do for my ID table is do an explicit lock on the record first, get the next ID, change the value in the table, THEN unlock the record. This way I do not get duplicate numbers, and I do not create unecessary calls to my error trapping routine for file access denied errors.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform