pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christof Petig <christof@petig-baender.de>
To: Cliff Wells <LogiplexSoftware@earthlink.net>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: ECPG and dynamic SQL
Date: Mon, 05 Aug 2002 17:45:32 +0200
Message-ID: <3D4E9D9C.1040301@petig-baender.de> (raw)
References: <1027981411.2433.30.camel@software1.logiplex.internal>
	<200207292337.g6TNb3rm025336@smtp-server6.tampabay.rr.com>
	<1028318503.5731.18.camel@software1.logiplex.internal>

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.




view thread (5+ messages)  latest in thread

Message-ID: <3D4E9D9C.1040301@petig-baender.de>
Permalink:  ../3D4E9D9C.1040301@petig-baender.de/
Also on:    postgresql.org/message-id/3D4E9D9C.1040301@petig-baender.de

 · 

reply

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: christof@petig-baender.de, LogiplexSoftware@earthlink.net
  Subject: Re: ECPG and dynamic SQL
  In-Reply-To: <3D4E9D9C.1040301@petig-baender.de>

* 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