Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to check for open table in vfp5.0
Message
 
 
To
09/07/1998 02:54:03
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00115596
Message ID:
00115601
Views:
13
>Hi,
>
> I am converting clipper 5.2 code to visual foxpro 5.0 code. There is
>a code in clipper 5.2 that test for whether table open is successful, it is also can check for whether the table is open in share mode, the command is NETERR().
>
> Which function in vfp 5.0 is best to replace this clipper 5.2 function.
>I had tried to use vfp USED() and ISEXCLUSIVE() and ERROR() function to check whether my table is open successfully, and whether other program had open the same table,yet the function use is not working as I expected like clipper function do.
>
>Any help is very much appreciated. Thank you.

Try this in command window:

1.
USE mytable IN 0
?USED('mytable') && returns .T.

2.
USE mytable IN 0 ALIAS mcalias
?USED('mytable') && returns .F.
?USED('mcalias') && returns .T.

3.
USE mytable IN 1
?USED(1) && returns .T.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform