Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement leaves table in use.
Message
From
25/01/2009 00:01:50
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01376809
Message ID:
01376811
Views:
10
Sweet!



>>Is there a way from keeping a SQL Select statement from leaving the tables open that is pulls from?
>>
>>I'm annoyed that if the tables are not already opem, it will open them (which is fine), but it leaves the tables open (i.e. USED).
>>
>>I wish it would close them back. Right now, I am doing a USE IN statement on about 4 tables to close them due to having been opended by a SQL Select statement.
>
>Check Class to close any cursors created after it was instantiated FAQ #31943
>
>So, you would instantiate this class before the select, then release it.
Previous
Reply
Map
View

Click here to load this message in the networking platform