>>VFP SQL Engine does not use already open tables or cursors in a query. It open them again similar to USE..AGAIN and closes after the query is complete. As result, active, index, filters, etc. on already open tables have no effect on the query.
>
>Are you sure about that? That VFP SQL Engine closes the table(s)? Maybe I misunderstood what you said but if I try to call SQL Select on a table the table is opened until explicitly closed.
>
>UPDATE: I read your reply to Jim and it clarified my question too.
Here is your update line.
If it's not broken, fix it until it is.
My Blog