Re: embedded SQL cursos declare fails

On Tue, 19 Jun 2001, Michael Meskes wrote:

> 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.

Correct, it works. But I was confused because the documentation (http://www.postgresql.org/idocs/index.php?ecpg-develop.html) mentions:

Open cursor statement
An open cursor statement looks like:
exec sql open cursor;
and is ignore and not copied from the output.

This gave me the impression that no explicit OPEN is necessary to operate on the cursor (normal Pg behavior). If not just my misunderstanding, someone rephrase thin in the docs.

cheers,
thalis

>
> Michael
> --
> Michael Meskes
> Michael(at)Fam-Meskes(dot)De
> Go SF 49ers! Go Rhein Fire!
> Use Debian GNU/Linux! Use PostgreSQL!
>