>>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
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison