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

From: 박재현[기술연구소] <jh_park(at)warevalley(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: <orange(at)warevalley(dot)com>
Subject: PostgreSQL) How to use Bind Variable with ODBC Driver V10?
Date: 2018-02-13 04:56:30
Message-ID: 1518497790.25902.197.jh_park@warevalley.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello. 

I hope my email finds you well. 

I am developing query tool for PostgreSQL using ODBC Driver (recent release ODBC v10).

The product that I am developing uses the SQLDescribeParam() function before the query SQLExec() when using Bind Variable. 

SQLDescribeParam () function normally works on 'psqlodbc_09_06_0500-x86', when using Bind Variable. 

However, in 'psqlodbc_10_00_0000-x86' and later versions, error occurs and Bind Variable cannot be used. 

Normal queries that do not use the SQLDescribeParam () function work fine. 

For your reference, below is the example of the query that use Bind Variable: select * from pg_class where relname = $ 1;

Should I use Bind Variable from ODBC v10 instead of SQLDescribeParam () function? 

If possible please provide me with a detailed guide on how to use Bind Variable with ODBC Driver. 

Thank you in advance. 

Best Regards,

 

 

 

박 재 현 Jae Hyun Park

전임연구원 / (주)웨어밸리 기술연구소

(121-795) 서울시 마포구 월드컵북로 396 (상암동)

누리꿈스퀘어 비지니스타워 22층

Tel: 02-2132-5522

Fax:02-743-4912

Mobile: 010-3836-9574

E-mail: jh_park(at)warevalley(dot)com

 

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Clemens Ladisch 2018-02-13 18:07:51 Re: PostgreSQL) How to use Bind Variable with ODBC Driver V10?
Previous Message Tobias Wendorff 2018-02-12 17:44:32 NUMERIC type makes trouble in MS Access