From: hoelc <hoelc@pd.jaring.my>
To: Michael Meskes <Michael_Meskes@topmail.de>
Cc: James Thompson <jamest@math.ksu.edu>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] facing problem with ecpg
Date: Fri, 12 Feb 1999 00:42:34 +0800
Message-ID: <36C3087A.CD315794@pd.jaring.my> (raw)
References: <36BCE221.47837890@pd.jaring.my>
<Pine.GSO.4.05.9902061850530.6735-100000@noether.math.ksu.edu>
<19990207200346.A254@gmx.net>
Hello,
I've just upgrated my PostgreSQL system to version Postgres-6.4.2
Now it has the *ecpg
But I'm facing problem in using it, when I compile the C program with
cc -o tryecpg tryecpg.c -lecpg -lpq
the compiler can't recognize the " exec sql ", and give error massage
Parse error before 'sql'
What went wrong ? Please advise.
Thanks for giving me the address for the Oracle Pre*C/C++ programmer's guide, it
is a good reference. But, it doesn't exactly reflect the ecpg, right? Is there
any reference and example program for how to use ecpg?
Thank you very much.
Regards,
LCH
Michael Meskes wrote:
> On Sat, Feb 06, 1999 at 07:16:14PM -0600, James Thompson wrote:
> > http://www.dal.ca/%7eoracle/oradoc/DOC/api/doc/PC_22/toc.htm
>
> Gotta look at this.
>
> > With it you end up with something like the following in your code
> >
> > exec sql
> > insert into customer(id,name_first,name_middle,name_last,company,
> > address1,address2,city,state,country,zip,phone_work,
> > phone_home,phone_fax,email,date_entered,billing_terms,
> > confirmation_method)
> > values (:id,:name_first, :name_middle, :name_last,
> > :company,:address1,:address2,
> > :city,:state,:country,:zip,:phone_work,
> > :phone_home,:phone_fax,:email,date('now'),
> > :billing_terms,
> > :confirmation_method);
>
> Xou can even add indicators like in
>
> ... values (:id,:name_first, :name_middle:nm_ind, :name_last, ...
>
> If nm_ind is set to -1 the name_middle entry will be set to NULL.
>
> > The author of the code is very responsive to few problem reports I have
> > sent him and has sent patches, or workarounds to me usually within 24
> > hours.
>
> Glad I can help. :-)
>
> > In the few cases you can't figure out a way to make something happen using
> > ecpg I believe you can mix the libpg and ecpg code in the same program.
> > The only place I could see a need for this is when you'd need the
> > functionality given by Pro*C's Dynamic SQL which ecpg doesn't yet support,
> > but I think its in the works.
>
> It is. In fact I already submitted a patch for the PREPARE and EXECUTE
> commands. James, if you'd like to test this I can send you the source until
> it makes its way into CVS.
>
> Michael
> --
> Michael Meskes | Go SF 49ers!
> Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
> Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
> Email: Michael.Meskes@gmx.net | Use PostgreSQL!
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: hoelc@pd.jaring.my, Michael_Meskes@topmail.de, jamest@math.ksu.edu
Subject: Re: [INTERFACES] facing problem with ecpg
In-Reply-To: <36C3087A.CD315794@pd.jaring.my>
* 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