>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
Yes, or you can issue
USE IN myTable
rather than explicitly switching work areas. If a SQL Select creates a filtered view rather than a separate cursor, you may end up destroying access to the cursor by closing the base table; you can avoid this by issuing a NOFILTER clause in the SQL Select if you expect that the query operates against a single table and is fully Rushmore optimizable.
>... what is a good practice: after SQL SELECT statement, manually close myTable & use xTemp cursor??