Re: [INTERFACES] esql\c documentation - Mailing list pgsql-interfaces

From Ivo Simicevic
Subject Re: [INTERFACES] esql\c documentation
Date
Msg-id 19990614133421.A10311@ultra.hr
Whole thread Raw
In response to esql\c documentation  ("Brent Waldrop" <waldrop_brent@hotmail.com>)
List pgsql-interfaces
On Sun, Jun 13, 1999 at 07:24:52PM -0500, Brent Waldrop wrote:
> EXEC SQL declare democursor cursor for
>  select fname,lname
>  into :fname, :lname
>  from employee
> where lname < :oneline;
> ---it bombs at the line with "into" in it saying there is a parse error

You don't use INTO clause in DECLARE section. 
You have to place in into             EXEC SQL FETCH IN democursor             INTO :fname, :lname
> and when i do this EXEC SQL fetch democursor;
> --it tells me that there is another parse error on this line
See above.

GL, Ivo.


pgsql-interfaces by date:

Previous
From: "ole-jorgen.bjerve"
Date:
Subject: ...
Next
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] esql\c documentation