Re: ECPG - connection name in "EXEC SQL AT ... " statement - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: ECPG - connection name in "EXEC SQL AT ... " statement
Date
Msg-id 20011023085649.A1111@feivel.fam-meskes.de
Whole thread Raw
In response to ECPG - connection name in "EXEC SQL AT ... " statement  (Edward Pilipczuk <edx@astercity.net>)
Responses Re: ECPG - connection name in "EXEC SQL AT ... " statement
List pgsql-interfaces
On Mon, Oct 22, 2001 at 10:34:59AM +0200, Edward Pilipczuk wrote:
> I've faced with the problem when trying to pass dynamically connection name 
> to DB into the "EXEC SQL AT ..." statement.

Hmm, the AT statement was never designed to get a dynamic connection name.
It appears there was some interaction with other changes.

> { ECPGdo(__LINE__, dbcn, "select value from table_name where key  = ?  ", 

It did accept "dbcn" as connection name, but also add it to the variable
list, which of course is not correct.

> Is there any other solution ?

Use a static connection name? :-)

Just joking, this is a bug that has to be fixed.

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!


pgsql-interfaces by date:

Previous
From: "Sudheer Palaparambil"
Date:
Subject: REMOVE PROCEDURE CALLS
Next
From: Christof Petig
Date:
Subject: ECPG: Missing in SQL standard? getting _one_ row out of a multirow descriptor