Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking for a table being in use
Message
From
23/07/2003 14:21:13
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Checking for a table being in use
Miscellaneous
Thread ID:
00812873
Message ID:
00812873
Views:
40
Using VFP8, is there a way to tell if a table is in use if that table was opened with a different alias?

For example:
**************************
USE employee IN 0 ALIAS emp &&This is OK.

***However, later on in the application...
IF !USED("employee") &&This will return TRUE.
USE employee IN 0 &&This would result in a File In Use error.
ENDIF
SELECT employee &&This would also error.
**************************

I know this isn't the best practice but how could I tell if employee is already in use in the current data session?

Thanks,

Jerry
Next
Reply
Map
View

Click here to load this message in the networking platform