Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force a table close
Message
From
27/02/2007 10:49:42
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01198482
Message ID:
01199150
Views:
13
Yes, thanks Dan. I am currently using your suggestion of CLOSE ALL, although I don't like having to reopen the project after it runs. It seems like there should be a better way.

This message was in reply to a suggestion that I simply USE AGAIN which doesn't work in this case because I need EXCLUSIVE.


>You need to make sure it's closed before you can get exclusive use.
>
>Again, CLOSE ALL would do the trick.
>
>>Later in the routine I need to pack the table so I need exclusive possession of the file.
>>
>>>Just add the AGAIN clause to the use commands;
>>>
>>>
>>>
>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\rawdata2005 AGAIN in 0 alias rawdata2005
>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\history AGAIN in 0 alias history
>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\companyinfo AGAIN in 0 alias companyinfo
>>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform