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 Knight
Progressive Impressions International
Bloomington, IL
Wise men talk because they have something to say; fools, because they have to say something.
-Plato