Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot close table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523066
Message ID:
00523279
Views:
14
>I am using the following to close a data table
>
>IF USED("TABLEA")
> USE IN TABLEA
>ENDIF
>
>
>When the program gets to the line USE IN TABLEA, it stops. The table is a member of DBC, contains no memo fields , and four indexes(no compound indexes).
>
>What could cause this?

This works for me:

IF USED('tablea')
SELECT tablea && select the open table
use && closes the table in the current work area

otherwise I think you are using a second instant of the table and then closing the second instance, leaving the original one still open.
MSCE, MCSP, Microsoft Channel Partner

Relax, Boss. We will meet the deadline! What? You want to add MORE? What do you mean, Over Budget?

Opinions and comments are the sole responsibility of the sender, and accuracy, correctness, or pertinence is considered coincidental.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform