pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
ECPG and sqlda 2+ messages / 2 participants [nested] [flat]
* ECPG and sqlda @ 2000-01-06 07:46 Tim Kane <timk@hotgames.com> 2000-01-07 20:16 ` Re: [INTERFACES] ECPG and sqlda Michael Meskes <meskes@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: Tim Kane @ 2000-01-06 07:46 UTC (permalink / raw) To: pgsql-interfaces Hmm, my second ECPG question... There doesn't seem to be any support for the SQLDA... Does this mean that I can't do proper dynamic queries? eg: select * from :table where :field = :result Somebody please tell me that I'm wrong! The test files in the source don't seem to utilize this feature at all. Oh, while I'm at it... ECPGstatus() seems to have changed to ECPGstatus (int, const char); What exactly am I supposed to pass to this function? Thanks Heaps! Tim. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ECPG and sqlda 2000-01-06 07:46 ECPG and sqlda Tim Kane <timk@hotgames.com> @ 2000-01-07 20:16 ` Michael Meskes <meskes@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Michael Meskes @ 2000-01-07 20:16 UTC (permalink / raw) To: Tim Kane <timk@hotgames.com>; +Cc: pgsql-interfaces On Thu, Jan 06, 2000 at 06:46:52PM +1100, Tim Kane wrote: > There doesn't seem to be any support for the SQLDA... Correct. ECPG does not support SQLDA. AFAIK SQLDA is not standard anyway. > Does this mean that I can't do proper dynamic queries? > > eg: select * from :table where :field = :result You can. How about this? exec sql prepare STMT from "select * from ? where ? = ?"; exec sql declare cur cursor for STMT; exec sql open cur using :table, :field, :result; > Somebody please tell me that I'm wrong! > The test files in the source don't seem to utilize this feature at all. test[2|3].pgc do use prepare. > ECPGstatus() seems to have changed to ECPGstatus (int, const char); > What exactly am I supposed to pass to this function? The first argument is the line-number (i.e. __LINE__). The second is the connection name. If you do not have different connections you can use NULL as connection name or just use "CURRENT". Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL! ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-01-07 20:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-01-06 07:46 ECPG and sqlda Tim Kane <timk@hotgames.com> 2000-01-07 20:16 ` Michael Meskes <meskes@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox