>>>VFP does open table test during query execution but it gets closed after query is completed.
>>
>>I don't think that it's all material, but are you sure that VFP closes a table after SQL-execution?
>
>In this case VFP closes table test after SQL-execution. In general, VFP leaves tables referenced in the FROM clause and open by query open if they weren't open before query excution and closes them otherwise.
Yes, I meant in general.
Edward Pikman
Independent Consultant