Re: [INTERFACES] esql\c documentation

From: Ivo Simicevic <ivo(at)ultra(dot)hr>
To: Brent Waldrop <waldrop_brent(at)hotmail(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] esql\c documentation
Date: 1999-06-14 11:34:21
Message-ID: 19990614133421.A10311@ultra.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Georg Ritter 1999-06-14 14:25:33 JDBC Driver 6.5 where to get?
Previous Message ole-jorgen.bjerve 1999-06-14 10:56:02