>It has ALWAYS annnoyed me that when issuing a SQL Select statement (on tables that are not USED yet), that VFP will USE the table and then *LEAVE IT OPEN*. I would prefer that it not be left open (unless it was already in USE)
>
>
>#CloseDaTableFoxPro

You can use this class: http://www.levelextreme.com/ViewPageNewFAQ.aspx?ID=31943 - when the object destroys, it will close anything that wasn't open when it was created. You just need to pick the right time when to instantiate it.