Received: from ip.zadarnet.hr (qmailr@ip.zadarnet.hr [195.29.197.33])
	by hub.org (8.9.3/8.9.3) with SMTP id HAA17682
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 14 Jun 1999 07:31:11 -0400 (EDT) (envelope-from ivo@ultra.hr)
Received: (qmail 10481 invoked by uid 1001); 14 Jun 1999 11:34:21 -0000
Date: Mon, 14 Jun 1999 13:34:21 +0200
From: Ivo Simicevic <ivo@ultra.hr>
To: Brent Waldrop <waldrop_brent@hotmail.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] esql\c documentation
Message-ID: <19990614133421.A10311@ultra.hr>
References: <19990614002236.83551.qmail@hotmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.95.3i
In-Reply-To: <19990614002236.83551.qmail@hotmail.com>;
	from Brent Waldrop on Sun, Jun 13, 1999 at 07:24:52PM -0500

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.