Re: PostgreSQL) How to use Bind Variable with ODBC Driver V10? - Mailing list pgsql-odbc

From Clemens Ladisch
Subject Re: PostgreSQL) How to use Bind Variable with ODBC Driver V10?
Date
Msg-id 610cd003-3c78-82dc-a21e-0652ef8307d1@ladisch.de
Whole thread Raw
In response to PostgreSQL) How to use Bind Variable with ODBC Driver V10?  (박재현[기술연구소] <jh_park@warevalley.com>)
List 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 by date:

Previous
From: 박재현[기술연구소]
Date:
Subject: PostgreSQL) How to use Bind Variable with ODBC Driver V10?
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: ODBC - Retrieving info messages - RAISE NOTICE