Re: ECPG and dynamic SQL

From: Cliff Wells <LogiplexSoftware(at)earthlink(dot)net>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: ECPG and dynamic SQL
Date: 2002-08-02 20:01:43
Message-ID: 1028318503.5731.18.camel@software1.logiplex.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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.

> cheers
> Jim Parker
>
> On 29 Jul 2002, Cliff Wells wrote:
> > Date: 29 Jul 2002 15:23:30 -0700
> > To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
> > From: Cliff Wells <LogiplexSoftware(at)earthlink(dot)net>
> > Sender: pgsql-interfaces-owner(at)postgresql(dot)org
> > Subject: [INTERFACES] ECPG and dynamic SQL
> >
> > I'm porting an application from a proprietary database format to
> > PostgreSQL using ECPG. My problem is that the application uses a single
> > function to get a record from the database. Based upon which table is
> > being accessed, it dynamically calculates column sizes and returns the
> > record in a structure. Creating the query itself is fairly
> > straightforward, but I am unable to figure out how to retrieve the
> > _results_ of the query as I have no place to store them (since I don't
> > know what they will be until the function is called I can't use a EXEC
> > SQL DECLARE section).
> >
> > It seems Oracle's sqlda would be a possible solution, but I understand
> > that isn't implemented in PostgreSQL.
> >
> > What is the best way to store the results of a dynamic query without
> > knowing what the results will be beforehand (using ECPG, if possible)?
> >
> > I'm using PostgreSQL 7.2.1 on SCO OpenSwerver.
> >
> > --
> > Cliff Wells, Software Engineer
> > Logiplex Corporation (www.logiplex.net)
> > (503) 978-6726 x308 (800) 735-0555 x308
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Cliff Wells, Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 x308 (800) 735-0555 x308

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Iavor Raytchev 2002-08-03 09:56:58 pgaccess anoncvs fixed
Previous Message Brett Schwarz 2002-08-02 11:11:44 Re: [pgaccess-users] pgaccess BusinessExchange