Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem - Error FILE IS IN USE
Message
 
 
À
04/04/2003 13:02:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00774121
Message ID:
00774135
Vues:
17
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform