Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use in file- not woking help
Message
From
28/01/1999 20:15:04
 
 
To
28/01/1999 19:14:04
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00181608
Message ID:
00181614
Views:
10
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform