Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Open files
Message
 
À
18/06/2007 11:49:11
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Network:
Windows 2003 Server
Divers
Thread ID:
01233987
Message ID:
01233996
Vues:
8
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform