From: | "Michael Kochetkov" <mkochetkov(at)hotmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Query batches and SQLMoreResults |
Date: | 2006-12-18 19:00:38 |
Message-ID: | BAY114-F8B0EFC39EC4E8FAEAF295CEC90@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail
From | Date | Subject | |
---|---|---|---|
Next Message | lothar.behrens@lollisoft.de | 2006-12-18 22:53:44 | Still SQLSetPos problem even with minimal sample, SQL_NULL_DATA and SQL_COLUMN_IGNORE ? |
Previous Message | Hiroshi Inoue | 2006-12-18 06:42:45 | Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when |