Skip site navigation (1) Skip section navigation (2)

Query batches and SQLMoreResults

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 (view raw or flat)
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


Responses

pgsql-odbc by date

Next:From: lothar.behrens@lollisoft.deDate: 2006-12-18 22:53:44
Subject: Still SQLSetPos problem even with minimal sample, SQL_NULL_DATA and SQL_COLUMN_IGNORE ?
Previous:From: Hiroshi InoueDate: 2006-12-18 06:42:45
Subject: Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group