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

Re: ECPG and dynamic SQL

From: Cliff Wells <LogiplexSoftware(at)earthlink(dot)net>
To: Christof Petig <christof(at)petig-baender(dot)de>
Cc: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: ECPG and dynamic SQL
Date: 2002-08-05 16:11:47
Message-ID: 1028563907.4210.6.camel@software1.logiplex.internal (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


In response to

pgsql-interfaces by date

Next:From: Hal DavisonDate: 2002-08-05 16:24:36
Subject: Most common IDE?
Previous:From: Christof PetigDate: 2002-08-05 15:45:32
Subject: Re: ECPG and dynamic SQL

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