Re: ECPG - connection name in "EXEC SQL AT ... " statement

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: ECPG - connection name in "EXEC SQL AT ... " statement
Дата
Msg-id 20011023085649.A1111@feivel.fam-meskes.de
обсуждение исходный текст
Ответ на ECPG - connection name in "EXEC SQL AT ... " statement  (Edward Pilipczuk <edx@astercity.net>)
Ответы Re: ECPG - connection name in "EXEC SQL AT ... " statement
Список 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 по дате отправления:

Предыдущее
От: "Sudheer Palaparambil"
Дата:
Сообщение: REMOVE PROCEDURE CALLS
Следующее
От: Christof Petig
Дата:
Сообщение: ECPG: Missing in SQL standard? getting _one_ row out of a multirow descriptor