Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use in file- not woking help
Message
De
28/01/1999 20:15:04
 
 
À
28/01/1999 19:14:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00181608
Message ID:
00181614
Vues:
11
>SELECT * FROM cas a INTO DBF ;
>(loutputfile+'cas');
>WHERE YEAR(closing) = lYear
>USE in cas ---------- cas in outputfile folder close ?
>USE IN a -- cas in current folder close ?


Ok. You have closed 'cas', but there is no alias 'a'. 'a' is only used inside the SQL statement to make the statement easier to write. You still have not closed (loutoutFile + 'cas').


>USE (loutputfile+'cas') IN 0 EXCLUSIVE ----no error given

Something is wrong here. You should get an error with the above statement, because the table is still open. Even if you use the AGAIN clause, you will get no error, but the table will not be opened exclusively.


>SELECT cas ----cannot select alias

Right. You closed the table earlier.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform