Re: embedded SQL cursos declare fails - Mailing list pgsql-general

From Michael Meskes
Subject Re: embedded SQL cursos declare fails
Date
Msg-id 20010619084355.B1497@feivel.credativ.de
Whole thread Raw
In response to embedded SQL cursos declare fails  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Responses Re: embedded SQL cursos declare fails  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
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!

pgsql-general by date:

Previous
From: Namrata
Date:
Subject: Alternate Database Location.
Next
From: "Itzinger, Oskar"
Date:
Subject: [Help] Temporary Table: Implicitely created index not shown in \d i