Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id MAA33547
	for pgsql-interfaces@postgresql.org;
	Tue, 25 May 1999 12:50:37 -0400 (EDT) (envelope-from news)
X-Authentication-Warning: hub.org: news set sender to <news> using -f
From: Johan Geuze <lorddark@xs4all.nl>
Subject: FETCH / ecpg
Date: Tue, 25 May 1999 18:53:36 +0200
Organization: XS4ALL Internet BV
Message-ID: <374AD590.278F8932@xs4all.nl>
To: pgsql-interfaces@postgreSQL.org

i'm having trouble with FETCH and ecpg..

I just get an compile error on this line


    EXEC SQL BEGIN WORK;
    EXEC SQL DECLARE cursxxx CURSOR FOR
        SELECT nr, xpos, ypos
        INTO :ster, :xpos, :ypos
        FROM stars;

-> EXEC SQL FETCH all in cursxxx;
     EXEC SQL CLOSE cursxxx;
     EXEC SQL COMMIT;

i know this should work.. at least on a informix database..

The man for fetch tells me the same..

what am i doing wrong?

or is this option not supported for enbedded sql in c..?

plz help!

Johan Geuze