ecpg fetch - Mailing list pgsql-interfaces

From David Chays
Subject ecpg fetch
Date
Msg-id Pine.SUN.3.91.990811141312.15861B-100000@photon.poly.edu
Whole thread Raw
List pgsql-interfaces

We followed the syntax for cursors from a standard SQL book
but are getting a compilation error on the line               exec sql fetch in repcurs into :choices;

Thanks for your help,
-David, Dan

exec sql include sqlca;
..
exec sql begin declare section;         int  choices;
exec sql end declare section;
..
exec sql declare repcurs cursor for       select number from singer;
..
exec sql open repcurs;

exec sql whenever not found goto done;       
for (;;)       {               exec sql fetch in repcurs into :choices;               printf("Number %d \n", choices);
    }
 

done:   exec sql close repcurs;



pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] libpgtcl and array fields return format - PROPOSAL
Next
From: "Hiroki Kataoka"
Date:
Subject: RE: PgAccess 0.97 - final preview