Re: -404 on OPEN cursor

}From: Daniel Wright <danwright@bigfoot.com> }Date: Mon, 14 Apr 1997 17:03:36 -0500 }X-Informix-List-Id: <news.36562> } }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) I'd probably need to see the code, but only after you've ensured that you are dealing with the following items... (1) Are these three statements sequential in the ESQL/C code (in which case, it superficially seems as if there is a problem), or is there other (eg I4GL) code in use in between the calls to these statements? (2) Is there any chance that the statement name or cursor name is used elsewhere in I4GL code which gets invoked at the wrong moment? (3) Are you compiling the ESQL/C code with the C4GL compiler and not (emphatically NOT) the ESQL/C compiler? Your ESQL/C compiler is 7.2x; your I4GL code expects to run with the 6.0x ESQL/C libraries provided with your 6.0x I4GL. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>