Include the NOFILTER clause to your select if you want to use the result in another select.
SELECT .... INTO CURSOR MyCursor NOFILTER ...
or select to table :-)
>What are "repackaged" cursors ? Does a certain type of query result in them ?
>I got the error when trying to use the resultant cursor from one query in the next query.
>
>This is what help says :
>
> "cursor" must be created with SELECT ... INTO TABLE (Error 1815)
> You have tried to use a repackaged cursor as a source for another SELECT statement.
> Some cursors cannot be used in successive queries.
>
>Jamie O
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca