>>>I have code similar to the two above SQL statements in multiple places. Sometimes even 3 or 4 SQL statments that all use the results of the previous SQL.
>>>Brenda
>>
>>
>>You've gotten lucky then. It doesn't happen in all cases, but it *can* happen. To see if your resultant cursor is a filtered view or not, use DBF(yourcursor) and see if it's the same as your table or some tempfile (.tmp). If you use the NOFILTER clause, it can't happen, you'll always get a .tmp file.
>>
>
>You also can force VFP to create a true cursor (without NOFILTER clause) if you add a calculated field to SQL, i.e.
>
>SELECT *, 000.00 AS somevalue FROM mytable INTO CURSOR temp
You can also add a "WHERE .t." to cause the same thing.