Query batches and SQLMoreResults

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?

Thank you in advance,
--
Michael Kochetkov

____________________________________________________________ _____
All-in-one security and maintenance for your PC.  Get a free 90-day trial!
http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/ ?href=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/dire ct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmai l


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match