Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem - Error FILE IS IN USE
Message
 
 
To
04/04/2003 13:02:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00774121
Message ID:
00774135
Views:
16
Isabelle,

This message means that you've table already open in current datasession in another workarea. You can change your code to check for such situation.
IF USED("profiles")
  SELECT profiles
ELSE 
  SELECT 0
ENDIF
use (oapp.cData+"profiles") share 
>Hello,
>
>In method LOAD a form (rapportusps), I have the following code:
>
>dodefault()
>set deleted on
>SET MULTILOCKS ON
>use (oapp.cData+"profiles") share in 0
>select profiles
>
>When this form calls and that I am with the following line:
>
>use (oapp.cData+"profiles") share in 0
>
>it gives me following error: FILE IS IN USE
>
>1-I checked when it makes the DODEFAULT(), it opens the table PROFILES
>(not, it does not open)
>
>2-I have make the program until the form rapportusps (method LOAD) and it opens the table PROFILES when it points the DODEFAULT() of method LOAD of the form rapportusps.
>
>3-but when it arrives at the line uses (oapp.cdata+"profiles") share in 0, it gives me errror following: FILE IS IN USE.
>
>4-I know that I could close the table PROFILES before but I know there is better a way of doing it.
>
>5-Moreover, I believe that the table PROFILES is open in exclusive mode when it gives me this error. (FILE IS IN USE)
>
>Thanks for help
>
>
>Isabelle L
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform