Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is a Table in Use
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Is a Table in Use
Miscellaneous
Thread ID:
01406905
Message ID:
01406905
Views:
108
I am trying to identify if a table is in use, by another use on a different pc,
and it could also be by a non Foxpro App (eg Report writer)
I need to reindex the table but cant do that if anyone else has file open

I have tried following:
liHandle = FOPEN(tcFileName,2)
IF liHandle = -1
* File could not be opened
llLocked = .t.
ELSE
* file can be opened exclusive
FCLOSE(liHandle)
ENDIF

However, On My own PC , if I use the command:
Use tcFilename
It returns that it is being used
Is there a way to find out, if other users on the network, apart from myself,
have the file open

TIA
Gerard
Next
Reply
Map
View

Click here to load this message in the networking platform