I have a table open; I issue a SQL against it; and then I check the Data Session. I see only one instance of the table and my query result. If the table is not open in the beginning, I see the same in the Data Session.

Does VFP then USE a open table AGAIN in a separate work area, perform the query, and then closes that table? Please explain this further so that I do have a better understanding of how that works, or perhaps I am not correctly utilizing the Data Session window...

>
>Jack,
>
>Interesting observation since your message is inaccurate. SQL ALWAYS reopens any tables with a USE AGAIN if they are already open. There can be a small performance boost if the tables are already open because USE AGAIN is faster than USE the first time.