>Even easier: add NOFILTER
>
>>>Thank you very much, it works!!!
>>>
>>>Thanks again :)
>>
>>Be aware this method only works when a physical cursor is created. Some queries (when using WHERE clause) result in a "virtual" cursor without a physical reality (filtered version of main table). So when processing the cursor via USE (DBF()) you are actually attaching to the TABLE and not the cursor.
>>
>>A safety net you can use is to always add a field to the SELECT that causes a physical cursor to br written:
>>
>>
>>SELECT *, .T. as Junk from MyTable into Cursor MyCursor
>>
>>
>>This guarantees that a physical cursor will be created.
True, but NOFILTER is a recent addition, this works all the way back to 2.6 and I am not sure what version they are using.
John White [MOST]