Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 25398475806
	for <pgsql-interfaces@postgresql.org>;
	Mon,  5 Aug 2002 11:45:32 -0400 (EDT)
Received: from mail.mediaways.net (mail.mediaways.net [193.189.224.113])
	by postgresql.org (Postfix) with SMTP id EBA1B475775
	for <pgsql-interfaces@postgresql.org>;
	Mon,  5 Aug 2002 11:45:30 -0400 (EDT)
Received: (qmail 2203 invoked by uid 4221); 5 Aug 2002 15:45:35 -0000
Received: from unknown (HELO gateway.petig-baender.de) (213.20.48.215)
	by smtp-relay.mediaways.net with SMTP; 5 Aug 2002 15:45:35 -0000
Received: from puck.petig-baender.de
	([192.168.234.11] helo=petig-baender.de ident=christof)
	by gateway.petig-baender.de with esmtp (Exim 3.35 #1 (Debian))
	id 17bk33-0004VO-00; Mon, 05 Aug 2002 17:45:33 +0200
Message-ID: <3D4E9D9C.1040301@petig-baender.de>
Date: Mon, 05 Aug 2002 17:45:32 +0200
From: Christof Petig <christof@petig-baender.de>
Organization: Adolf Petig GmbH & Co. KG
User-Agent: Mozilla/5.0 (X11; U; Linux ppc; de-AT;
	rv:1.0.0) Gecko/20020614 Debian/1.0.0-3
X-Accept-Language: de-DE, de, en
MIME-Version: 1.0
To: Cliff Wells <LogiplexSoftware@earthlink.net>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: ECPG and dynamic SQL
References: <1027981411.2433.30.camel@software1.logiplex.internal>
	<200207292337.g6TNb3rm025336@smtp-server6.tampabay.rr.com>
	<1028318503.5731.18.camel@software1.logiplex.internal>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/18
X-Sequence-Number: 2980

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.