Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbused in other work area
Message
 
To
13/01/2008 12:09:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01281470
Message ID:
01281473
Views:
6
>Hi
>I want to check if the database open.
>When I used with 'dbused' I get .f. (not open) even when it's open by other user network.
>PS
>There is such command for check if tables exclusive?

Check with try...catch
TRY 
   USE e:\...\YourdataBase.dbc EXCLUSIVE 
   ...
   some code
   ...
CATCH 
   MESSAGEBOX("The Database is open")
ENDTRY
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform