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

박재현[기술연구소] 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