Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use In Anomaly
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00621413
Message ID:
00621420
Views:
8
Hi Charles,

In addition to closing table you have to close database. E.g.:
set database to dbcName
close database

>Hi All!
>I have this routine in my app in its load event that checks to see if a database table is open or not by this command:
>
>Use dbcName!dbfTable In 0 Alias dbfTable
>
>If opening this database table returns successfully, then loading continues, if not, a message box appears saying that another app is using this particular table. And then immediately following the command earlier is this command:
>
>Use In dbfTable
>
>Now my problem is that if no error occurs (meaning my app is the only app that can use the database tables since i can use dbfTable exclusively) and I try to copy the database file to another directory, an error occurs which reads "File is in use". How come? Didn't I already close the said table by issuing a "Use In" command? What could be a "better" way to close a specific table?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform