Getting Recordset through returning refcursor

"Kubilay Kaan" <[email protected]> Fri, 15 Nov 2019 13:05:00 +0100
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <trinity-1522e455-0c2c-4157-a8c2-c29002e33840-1573819500211@3c-app-gmx-bs65>
Hello friends,
=C2=A0
hopefully I am right here bcz its my first post so=2E=2E
=C2=A0
I am using the=C2=A0Provider=3DMSDASQL=2E1 through psqlODBC as Data Source=
(created user DSN)=2E
Postgresversion is 12=2E
Programming language is C++=2E
OS =3D Windows 10=2E
=C2=A0
So my problem is when I call a sql function which returns a refcursor for =
dynamic sql purposes it doesnt fill the recordset=2E
=C2=A0
So my question is does the ODBC driver supports refcursor??
=C2=A0
Is there any example/codesnippet or any sugestions? I did search alot abt =
this topic without success=2E

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

as well as spREFRecordset->Open(_T("select GetRecordSetByID_ref('refcur', =
1); FETCH ALL IN \"refcur\";"), spConnection=2EGetInterfacePtr(), adOpenFor=
wardOnly, adLockOptimistic, adCmdText);

I always get an empty recordset
=C2=A0
=C2=A0
Thx in advance=2E=2E