>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??

Tables are opened, but not closed, automatically.

If you have a form with a private datasession (the recommended, but not the default, setting!), there is no need to close tables explicitly.

HTH, Hilmar.