Re: R: ODBC 7.0006 bugs - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: R: ODBC 7.0006 bugs
Date
Msg-id 3B452281.E5C2B10C@tpf.co.jp
Whole thread Raw
In response to ODBC 7.0006 bugs  ("David Ciarniello" <brainlost@rocketmail.com>)
List pgsql-odbc
David Ciarniello wrote:
>
> > David Ciarniello wrote:
> > >
> > > I found some bugs working with Access'97-ODBC 7.006 on a Win98 client
> and
> > > PostgreSQL 7.1.2 on a  Redhat 6.2 server:
> > >

[snip]

> >
> > > 2) updating a table without row versioning:
> > >
> > > I can't update a table with a float field (but the problem could affect
> also
> > > other kind of fields) with row-versioning deactivated.
> >

[snip]

>
> Now I understood a thing that appeared weird to me; the driver uses all
> fields to identify a row (even if there's a unique column) to avoid
> concurrent changes.
> I think that the problem could be solved identifying some fields with a
> between operator (with a very small range) instead of an equal (=) operator;

Unfortunately it's the application like DAO-JET not the driver
which issues the queries.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: "David Ciarniello"
Date:
Subject: R: ODBC 7.0006 bugs
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: RE: ODBC 7.0006 bugs