Getting Recordset through returning refcursor

From: "Kubilay Kaan" <heraklea(at)gmx(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Getting Recordset through returning refcursor
Date: 2019-11-15 12:05:00
Message-ID: trinity-1522e455-0c2c-4157-a8c2-c29002e33840-1573819500211@3c-app-gmx-bs65
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello friends,
 
hopefully I am right here bcz its my first 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.

I did try it as -> spRecordset = spCommand->Execute(NULL, NULL, 0);

as well as spREFRecordset->Open(_T("select GetRecordSetByID_ref('refcur', 1); FETCH ALL IN \"refcur\";"), spConnection.GetInterfacePtr(), adOpenForwardOnly, adLockOptimistic, adCmdText);

I always get an empty recordset
 
 
Thx in advance..

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Clemens Ladisch 2019-11-15 13:29:18 Re: Getting Recordset through returning refcursor
Previous Message Andrew Kagan 2019-11-14 23:03:30 Windows ODBC Driver configuration help