Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When does the table used in SQL SELECT close?
Message
From
20/12/2001 12:05:25
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
To
20/12/2001 11:57:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00596837
Message ID:
00596843
Views:
33
hi your table will beclose when you issue a close data all or close all
About your question the answer is yes you should close the table if you don't need it this is also applicable to the cursor.

>When using a SQL statement, does the database and/or the table need to be explicitly opened first (USE myTable, OPEN myDatabase ?), or does the SQL SELECT statement automatically opens up myTable?
>Another question:
>After a SQL SELECT statement, when does the table close?
>Example: SELECT * FROM myTable INTO CURSOR xTemp
>myTable automatically opens?
>When does myTable close: do I need to specifically close it:
>SELECT myTable
>USE
>... what is a good practice: after SQL SELECT statement, manually close myTable & use xTemp cursor??
Alexandre Palma
Senior Application Architect
Previous
Reply
Map
View

Click here to load this message in the networking platform