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
Thank you in advance,
All-in-one security and maintenance for your PC. Get a free 90-day trial!
pgsql-odbc by date
|Next:||From: firstname.lastname@example.org||Date: 2006-12-18 22:53:44|
|Subject: Still SQLSetPos problem even with minimal sample, SQL_NULL_DATA and SQL_COLUMN_IGNORE ?|
|Previous:||From: Hiroshi Inoue||Date: 2006-12-18 06:42:45|
|Subject: Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when|