Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force a table close
Message
From
23/02/2007 18:24:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Force a table close
Miscellaneous
Thread ID:
01198482
Message ID:
01198482
Views:
62
After running some other code which uses these tables, the following code produces an error on the first use stating the file is not available. If I exit VFP and then run the code it works OK. How can I force a close to make sure the tables are available?
close tables all
close databases all
set exclusive on

use \\tpdfiles\data\dfreeman\trp\data\surveys\rawdata2005 in 0 alias rawdata2005
use \\tpdfiles\data\dfreeman\trp\data\surveys\history in 0 alias history
use \\tpdfiles\data\dfreeman\trp\data\surveys\companyinfo in 0 alias companyinfo
Next
Reply
Map
View

Click here to load this message in the networking platform