Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flock()= exclusive use
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00291872
Message ID:
00291926
Views:
31
>>>If I want to get exclusive use of a dbf() on the network Can I simply test for someone using it first by issuing " ?flock()" so that I won't have to resort to an error routine?
>>
>>You can still get a file lock on a table that is open by another user as long as the other user has no records locked. While it is a good first clue to exclusivity, flock is not a guarantee that you can then open the table exclusively. Try:
>>lcOldError = on('error')
>>llOpen = .t.
>>on error llOpen = .f.
>>use mytable excl
>>on error &lcOldError
>>if !llOpen
>>   return .f.
>>endif
>
>Mark, does the used() command work,I just want to know if the file is being used at all by another user without an error routine. otherwise I will follow your example.

Nope. Used() will only tell you if the table is open in the current data session of the current user.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform