Re: -404 on OPEN cursor

Daniel Wright wrote: > > This is either something really stupid on my part, or a real problem. > > I prepare a select statement > (SQLCODE == 0) after the prepare > I Declare a cursor for the prepared statement > (SQLCODE == 0) after the declare > I OPEN the cursor I just declared > SQLCODE == -404 (Cursor not available) > > I triple checked that the cursor name I tried to open was the same as > the one I declared, and did the same for the statement I prepared and > declared the cursor from. > > Any ideas will be most appreciated, > > (The cursor appears in an ESQL/C module which is compiled along with a > 4GL module into an executable - the cursor is in the E/C because that's > where the variables I intend to use exist; > I wrote a short EC program to verify that I was preparing, declaring > and opening properly; > HP-UX 10; Informix 7.21) Daniel, Please put a snippet of you code out for everyone to look at. Without letting us look at the code, you're just shooting in the dark. Thanks, Bret.