Getting Recordset through returning refcursor
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hello friends,</div>
<div> </div>
<div>I am not sure if I am right here bcz its my forst post so..</div>
<div> </div>
<div>I am using the Provider=MSDASQL.1 through psqlODBC as Data Source(created user DSN).</div>
<div>Postgresversion is 12.</div>
<div>Programming language is C++.</div>
<div>OS = Windows 10.</div>
<div> </div>
<div>So my problem is when I call a sql function which returns a refcursor for dynamic sql purposes it doesnt fill the recordset.</div>
<div> </div>
<div>So my question is does the ODBC driver supports refcursor??</div>
<div> </div>
<div>Is there any example/codesnippet or any sugestions? I did search alot abt this topic without success.</div>
<div> </div>
<div> </div>
<div>Thx in advance..</div></div></body></html>
Hello friends,
I am not sure if I am right here bcz its my forst post so..
I am using the Provider=MSDASQL.1 through psqlODBC as Data Source(created user DSN).
Postgresversion is 12.
Programming language is C++.
OS = Windows 10.
So my problem is when I call a sql function which returns a refcursor for dynamic sql purposes it doesnt fill the recordset.
So my question is does the ODBC driver supports refcursor??
Is there any example/codesnippet or any sugestions? I did search alot abt this topic without success.
Thx in advance..
On Fri, Nov 15, 2019 at 3:36 PM Kubilay Kaan <heraklea@gmx.de> wrote:
So my problem is when I call a sql function which returns a refcursor for dynamic sql purposes it doesnt fill the recordset.
So my question is does the ODBC driver supports refcursor??
I think the chances of getting an answer on ODBC related queries will
be more if you post on pgsql-interfaces.
--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
On Fri, Nov 15, 2019 at 03:55:28PM +0530, Amit Kapila wrote:
I think the chances of getting an answer on ODBC related queries will
be more if you post on pgsql-interfaces.
There is also a mailing list dedicated to Postgres ODBC:
https://www.postgresql.org/list/pgsql-odbc/
--
Michael