Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open files
Message
From
18/06/2007 11:55:19
 
 
To
18/06/2007 11:49:11
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
Network:
Windows 2003 Server
Miscellaneous
Thread ID:
01233987
Message ID:
01233996
Views:
9
This message has been marked as the solution to the initial question of the thread.
>>>Using FAQ #7896, by Ramon F. Jaquez, I can now find out which user has opened a certain file. Now, I would like to know which user have it open exclusive and which shared - but I don't see such an option in this download. Is it possible to get this information?
>>
>>If you can't open the file yourself (issue some command with error trap) then it's exclusive, if you can then it's shared.
>
>Sure. But: In my system, there is apparently some rogue process that keeps the file open exclusively, and I don't know which process it is, or which user is using it. So the question is not, did someone use it exclusively, but rather, who. I hope this will help me track down the error.
>
>FAQ #7896 tells me who is using some file, but not, whether it is exclusive.

If the file is opened EXCLUSIVE there is only ONE user who is opened it :-)
So you could try:
old_error         = ON([ERROR])
fl_error          = .f.
ON ERROR fl_error = .t.
USE (lcFile) SHARED
IF fl_error
   *** The file is opened exclusive
   *** use FAQ 7896 to get the name of who is the culprit
ENDIF
USE IN SELECT(lcFile)
ON ERROR &old_error
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform