>>I am converting some 2.6 code and am basically running some existing prgs. These programs have a series of SQL - SELECT statements creating cursors that are used in subsequent SQL - SELECT statements.
>>Sometimes though, the previous cursors are not visible to the subsequent statements, why? If I do the writeable cursor thing, USE (cursor) AGAIN IN 0 blah, blah.....the subsequent statements "see" the previous cursor. Anyone run into this before?
>>
>>Steve
>
>Yes, it's problem: VFP wants to have real cursor (not just filter on table). You can use NOFILTER clause to avoid this problem in VFP5 (in VFP3 you could add new field into field list to force the same).

Thanks for your reply. I've never seen anything like this but will apply the NOFILTER clause and test on Monday AM. Have a happy holiday season.

Steve Despres