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