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

Re: ECPG and dynamic SQL

From: Christof Petig <christof(at)petig-baender(dot)de>
To: Cliff Wells <LogiplexSoftware(at)earthlink(dot)net>
Cc: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: ECPG and dynamic SQL
Date: 2002-08-05 15:45:32
Message-ID: 3D4E9D9C.1040301@petig-baender.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
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.


In response to

Responses

pgsql-interfaces by date

Next:From: Cliff WellsDate: 2002-08-05 16:11:47
Subject: Re: ECPG and dynamic SQL
Previous:From: John L. TurnerDate: 2002-08-05 13:41:00
Subject: Re: Most common IDE?

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