Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File in Use Error
Message
From
10/03/2004 11:41:37
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
10/03/2004 11:31:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00884850
Message ID:
00884869
Views:
11
>>To know what is going on, use the SET command to interactively check for open tables.
>
>Hilmar, I have done this and the table is not USED(). However, trying to USE it without the AGAIN statement results in the file in use error. Trying to USE the table to close it shows the "alias mytable is not found" error. The only thing I can think of is that there is some unfiltered view being created somehow based on the table but I have only one SELECT statement for this table and that performs a SELECT INTO array operation.
>
>Paul

It may be opened in another DataSession, especially if you use forms with private datasessions. The SET command can also show this, but you have to select the different datasessions (if more than one is open).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform