Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open Excl
Message
From
05/07/2002 09:36:53
 
 
To
05/07/2002 08:10:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00675569
Message ID:
00675592
Views:
10
Hi Allen,
Yes, you can check if a table is opened excl without any error message.

*Prior to opening the table, disable the normal error handling...
ON ERROR ?""
*Attempt to open the table...
SELECT 0
USE mytable EXCL
IF EMPTY(ALIAS())
WAIT WINDOW "Cannot get exclusive use!"
ELSE
*You have opened the table exclusive!
ENDIF
*Be sure to restore the error handler!
ON ERROR

Hope that helps,
Julian
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform