If the SELECT is within a form, I have the table in the DE, and it gets closed automatically. If not used with a DE, I place this at the end of the code for each table SELECTed from:
IF USED('TableOpenedBySelect')
USE IN TableOpenedBySelect
ENDIFHTH!
Mark
>Is there any elegant solution to the problem of VFP opening tables used in a select and not closing them again when it's done, or do you just have to keep track of all of them manually and close them after the SELECT?
>
>-- jas
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.