Re: FUD!! ODBC will not be supported by Microsoft in the future

Ben Trewern wrote:

> All
>
> I've been using (or trying to use) the pgODBC driver with 'Use
> Declare/Fetch' set to true and all goes well till you try to go to the
> end of a large recordset.  The driver seems to load all the records
> instead of just the last 50 (or whatever).  I'm using Delphi 7, BDE and
> psqlODBC version 7.03.01.08 to connect to Postgres 7.3.1.
>
> Any ideas?  Could this be a BDE problem?  Any one else out there using
> this configuration?
>
> Regards,
>
> Ben

According to what I gather from the thread here:


http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=7159b632785c579f&seekm=3E1BEFFE.88B57516%40tpf.co.jp#link13

PostgreSQL cannot perform a backward-scan and is forced to materialize
 the result set in its entirety. So that is a backend issue
specifically, not an ODBC issue, I'm afraid.

Mike Mascari
mascarm@mascari.com