Re: Query batches and SQLMoreResults

Michael Kochetkov wrote:
> Hello,
> let us consider the following test case. There are two tables T1 that
> has int and varchar fields and T2 that has varchar, datatime and blob
> fields. Then we have a query batch like this:
> select * from T1;
> select * from T2
>
> It executes with ODBC and gets the first recordset as expected. But then
> I have problems. SQLMoreResults says there is another recordset.
> SQLNumResultCols says there are 3 columns indeed. But subsequent
> SQLDescribeCol calls return wrond descriptions. The first call for it
> says, for example, that the first field of the second recordset is of
> type SQL_INTEGER while I expect it to be varchar. And subsequent
> SQLFetch fails.
>
> I use the latest PostgreSQL 8.2 binaries for Win32.
>
> So, does current PostgreSQL ODBC driver supports query batches and
> SQLMoreResults?

Please try the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.
At least SQLDescribeCol would return correct result.
SQLNumParams doesn't work properly though.

regards,
Hiroshi Inoue