Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-interfaces by date

Next:From: Craig OrsingerDate: 1999-05-25 17:26:59
Subject: Re: [INTERFACES] ECPG feature
Previous:From: tperryDate: 1999-05-25 15:23:44
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group