From: Ivo Simicevic <ivo@ultra.hr>
To: Brent Waldrop <waldrop_brent@hotmail.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] esql\c documentation
Date: Mon, 14 Jun 1999 13:34:21 +0200
Message-ID: <19990614133421.A10311@ultra.hr> (raw)
In-Reply-To: <19990614002236.83551.qmail@hotmail.com>
References: <19990614002236.83551.qmail@hotmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ivo@ultra.hr, waldrop_brent@hotmail.com
Subject: Re: [INTERFACES] esql\c documentation
In-Reply-To: <19990614133421.A10311@ultra.hr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox