Re: 8.1.1: recordset-paging severerly broken!

hi dave

how does one turn on use declare / fetch?

and yes, if you got a dll i'll happily test it

cheers,
thomas
----- Original Message -----
From: Dave Page
To: me(at)alternize(dot)com ; pgsql-odbc(at)postgresql(dot)org
Sent: Wednesday, November 09, 2005 4:32 PM
Subject: RE: [ODBC] 8.1.1: recordset-paging severerly broken!

----------------------------------------------------------------------------
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of me(at)alternize(dot)com
Sent: 09 November 2005 14:53
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] 8.1.1: recordset-paging severerly broken!

hi list

using pgsql 8.1 and odbc driver 8.1.1, the recordset paging is broken severerly!
only the first 100 records are returned. the 101th record is the 1st record again instead of the real 101th record from the db. when using a pagesize of 15, the following happens:

Argh! So wrapped up in fixing use declare/fetch that none of us noticed that non-declare/fetch mode broke :-(

I've committed a fix for this, thanks for the report. Would you like a test DLL to try? Alternatively, try turning Use Declare/Fetch on.

Regards, Dave