Re: Query batches and SQLMoreResults

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

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