Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.1.1: recordset-paging severerly broken! - Mailing list pgsql-odbc

From
Subject Re: 8.1.1: recordset-paging severerly broken!
Date
Msg-id 0c6401c5e544$978dda00$0201a8c0@iwing
Whole thread Raw
In response to Re: 8.1.1: recordset-paging severerly broken!  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-odbc
Tree view
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
Sent: Wednesday, November 09, 2005 4:32 PM
Subject: RE: [ODBC] 8.1.1: recordset-paging severerly broken!

 

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of me@alternize.com
Sent: 09 November 2005 14:53
To: pgsql-odbc@postgresql.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
 
 

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: 8.1.1: recordset-paging severerly broken!
Next
From: "Andrus"
Date:
Subject: 08.00.0102 with UTF8 database causes client encoding mismatch error