>I have a query where I am calling from a table and from a cursor. When my program gets to this line, I get the error "CONFLIST must be created with SELECT .... INTO TABLE." As you probably have guessed conflist is the cursor. I don't want to make conflist a table. The funny thing about this is that this line is called for another function and it works fine. I don't get it. I have never had a problem doing a query from a cursor before. Here is the query.
>
>SELECT O.* FROM conflist L, conford O INTO CURSOR tempord ;
> WHERE L.O_rec_id = O.O_rec_id
>
>Any help would be appreciated.
>
>Thanks
Brent,
Add
NOFILTER to your select
SELECT O.* FROM conflist L, conford O INTO CURSOR tempord <B>NOFILTER</B>;
WHERE L.O_rec_id = O.O_rec_id
--sb--