Getting Recordset through returning refcursor
От | Kubilay Kaan |
---|---|
Тема | Getting Recordset through returning refcursor |
Дата | |
Msg-id | trinity-1522e455-0c2c-4157-a8c2-c29002e33840-1573819500211@3c-app-gmx-bs65 обсуждение исходный текст |
Ответы |
Re: Getting Recordset through returning refcursor
|
Список | 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..
В списке pgsql-odbc по дате отправления: