General information
Category:
Coding, syntax & commands
Depending on the information that you require, you may need to use a third party product like GPLIB or equivalent. Alternatively, if you just wish to know if somebody is using a file, database, table etc., etc., you can use error trapping. For example:
llTableUsed = .F.
on error llTableUsed = .T. && Use error trapping
use C:\MyTable exclu && Attempt to open table exclusively
if llTableUsed && Therefore error created, table is in use
endif
All you're trying to do is open the table exclusively. If an error occurs then someone else must have the table open, if not then nobody is using it. This is rather crude, but it does work. Don't forget to close MyTable, or at least open it as shared........
Derek
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only