Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table closed but 'file is in use' ... ?
Message
 
To
12/03/2001 14:41:25
Fausto Garcia
Independent Developer
Lima, Peru
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Table closed but 'file is in use' ... ?
Miscellaneous
Thread ID:
00484196
Message ID:
00484199
Views:
15
>What might the problem be here?

SQL will open the source table filtered instead of creating a new cursor if it can.

Check the DBF() of the cursor and I bet it's your table. Add NOFILTER to the SQL statement to prevent SQL from doing this.
Dan Goodwin
Primary Data Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform