Re: PostgreSQL) How to use Bind Variable with ODBC Driver V10?

Поиск
Список
Период
Сортировка
От Clemens Ladisch
Тема Re: PostgreSQL) How to use Bind Variable with ODBC Driver V10?
Дата
Msg-id 610cd003-3c78-82dc-a21e-0652ef8307d1@ladisch.de
обсуждение исходный текст
Ответ на PostgreSQL) How to use Bind Variable with ODBC Driver V10?  (박재현[기술연구소] <jh_park@warevalley.com>)
Список pgsql-odbc
박재현[기술연구소] wrote:
> The product that I am developing uses the SQLDescribeParam() function
> before the query SQLExec() when using Bind Variable.

The behaviour of the driver for this case is affected by the
configuration settings "Parse Statement" and "Server side prepare".
What are their values?  Are they different in the old and new data
sources?  Does it help if you change one or both of them?

> select * from pg_class where relname = $ 1;

In theory, the ODBC API allows only ? as parameter marker; please use
that.  (The driver automatically changes ? to $N before sending the
statement to the server.)


Regards,
Clemens


В списке pgsql-odbc по дате отправления:

Предыдущее
От: 박재현[기술연구소]
Дата:
Сообщение: PostgreSQL) How to use Bind Variable with ODBC Driver V10?
Следующее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: ODBC - Retrieving info messages - RAISE NOTICE