Re: embedded SQL cursos declare fails

On Mon, Jun 18, 2001 at 03:59:56PM -0400, Thalis A. Kalfigopoulos wrote:
> EXEC SQL DECLARE my_cursor CURSOR FOR SELECT a,b FROM lala WHERE a= :i;
> EXEC SQL FETCH FORWARD NEXT FROM my_cursor INTO :tmpa,:tmpb;

Is there an EXEC SQL OPEN CURSOR my_cursor in between these lines?

> I check the .c file generated by ecpg and the cursor declaration is commented out :-(

That's correct. It's placed at the OPEN spot.

Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!