FETCH / ecpg

From: Johan Geuze <lorddark(at)xs4all(dot)nl>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: FETCH / ecpg
Date: 1999-05-25 16:53:36
Message-ID: 374AD590.278F8932@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Craig Orsinger 1999-05-25 17:26:59 Re: [INTERFACES] ECPG feature
Previous Message tperry 1999-05-25 15:23:44