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.