>>>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.
I see.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham