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

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL) How to use Bind Variable with ODBC Driver V10?
Date: 2018-02-13 18:07:51
Message-ID: 610cd003-3c78-82dc-a21e-0652ef8307d1@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2018-02-13 22:17:38 Re: ODBC - Retrieving info messages - RAISE NOTICE
Previous Message 박재현 2018-02-13 04:56:30 PostgreSQL) How to use Bind Variable with ODBC Driver V10?