Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use EXCLUSIVE opens the table READ ONLY!!!!!!
Message
 
 
To
19/02/1999 15:15:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00189463
Message ID:
00189510
Views:
10
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform