From: Cliff Wells <LogiplexSoftware@earthlink.net>
To: Christof Petig <christof@petig-baender.de>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: ECPG and dynamic SQL
Date: 05 Aug 2002 09:11:47 -0700
Message-ID: <1028563907.4210.6.camel@software1.logiplex.internal> (raw)
In-Reply-To: <3D4E9D9C.1040301@petig-baender.de>
References: <1027981411.2433.30.camel@software1.logiplex.internal>
<200207292337.g6TNb3rm025336@smtp-server6.tampabay.rr.com>
<1028318503.5731.18.camel@software1.logiplex.internal>
<3D4E9D9C.1040301@petig-baender.de>
On Mon, 2002-08-05 at 08:45, Christof Petig wrote:
> Cliff Wells schrieb:
> > On Mon, 2002-07-29 at 16:37, Jim Parker wrote:
> >
> >>The app GtkSQL does what you need, but it is implimented in libpq. It will
> >>give you a general idea of how to do it.
> >>
> >>Do a google search.
> >>
> >>There is another app that is similar (libpq also) a little less complex, so
> >>easier to follow, called dbui-0.4.0 A Google search will give you a URL
> >
> >
> > Yeah, I was afraid there was no way to do it using ecpg... oh well.
> >
> > Thanks for the info.
>
> Of course there is a way to do it in ecpg! Ecpg simply does not provide
> the (IMO) overloaded sqlda interface but uses the new lean get
> descriptor interface (SQL standard). See interfaces/ecpg/tests/dyntest*
> for an example.
>
> Christof
>
> PS: If you want to use this: you can even fetch into a char **results=0;
> but have to free the array afterwards.
>
Ah. Thank you very much! I don't know how I missed that. It seems the
quickest way to have someone tell you how to do something is to suggest
it can't be done ;)
Regards,
--
Cliff Wells, Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 x308 (800) 735-0555 x308
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: LogiplexSoftware@earthlink.net, christof@petig-baender.de
Subject: Re: ECPG and dynamic SQL
In-Reply-To: <1028563907.4210.6.camel@software1.logiplex.internal>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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