Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to know the access mode of an open table?
Message
 
 
To
16/10/2000 17:03:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00430015
Message ID:
00430057
Views:
24
>>I generally find sys(2011) more useful...

>I don't find a use for it at all, its easier to write ?IsExclusive() than ?sys(2011) = "EXCLUSIVE".

>Besides, it does have some issues, like, it will only tell you if a record is locked in the current app, not anywhere else, so to make sure you're truly safe to save, you should have:

>ISEXCLUSIVE() OR ISFLOCKED() OR ISRLOCKED()

ALL the functions discussed share the same weakness, they only report back on the current VFP session. Any table opened by another user or the same user in another VFP session, will not be reported properly...
-michael

My brain hurt like a warehouse, it had no room to spare, I had to cram so many things to store everthing in there. - David Bowie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform