>Make sure to add READWRITE clause to your select statement.
Didn't help.
>
>See
Re: How to pack a cursor? Thread #
1335982 Message #
1336418 (the whole thread) and check the link suggested in this message as well as another link on that site.
>
I've read this thread as it appeared and, sorry, but I don't see the relevance.
>
http://www.berezniker.com/content/pages/visual-foxpro/queries-and-filtered-cursors>
>>We have a module which creates a cursor and then returns its name. I need to further refine the selection but I'm getting an error that I'm hoping somebody here can explain.
>>myCursor = thisform.get_some_date(params)
>>this code works
>>SELECT * from (myCursor) WHERE id IN ;
>> (SELECT id FROM (myCursor) WHERE condition);
>> INTO CURSOR DifferentName
>>
>>but this code
>>SELECT * from (myCursor) WHERE id IN ;
>> (SELECT id FROM (myCursor) WHERE condition);
>> INTO CURSOR (myCursor)
>>
>>generates the Open Table dialog and then an error because it can't find the cursor (myCursor).
>>
>>It also works if I code it as
>>SELECT id FROM (myCursor) WHERE condition INTO CURSOR curHold
>>SELECT * FROM (myCursor) src;
>> JOIN curHold ch ON ch.id = src.id;
>> INTO CURSOR (myCursor)
>>
>>I'm curious as to what causes MyCursor to close when using it for the FROM, IN( ), and INTO CURSOR.
>>
>>Any thoughts appreciated.