Float Percision with MS Access 97 - Mailing list pgsql-odbc

From Michael Calabrese
Subject Float Percision with MS Access 97
Date
Msg-id 20010820160555.71744.qmail@web10708.mail.yahoo.com
Whole thread Raw
Responses Re: Float Percision with MS Access 97
List pgsql-odbc
If I have a table with a float4 and it has greater
precision that 4 to the left of the decimal point,
Access will not let me change that record and gives me
a write conflict.  I have troubleshooted the problem
to the point that Access when changing a record checks
all known fields as part of the update statement (even
though it has, and knows it has, the index).

For example: if I have a table with the following

Parts:
PartID  Name   Price   Count
555     Tubing 2.50    101.123456

MS Access seems to get the count from the ODBC driver
as 101.1234.  When you build a screen that has all of
the fields in the then change Price Access does the
following:

UPDATE Parts
SET Price = 2.75
WHERE PartID = 555
  AND Name = 'Tubing'
  AND Price = 2.5
  AND Count = 101.1234;

This causes a "write conflict" because the counts are
not equal.

Is there are way to get more precision from the ODBC
driver or am I missing a setting somewhere?

Thanks in advance,
Michael Calabrese
Bike Friday
m2calabr-AT-yahoo-DOT-com


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

pgsql-odbc by date:

Previous
From: "Johann Zuschlag"
Date:
Subject: New CVS doesn't compile
Next
From: "Johann Zuschlag"
Date:
Subject: Stackerror using new CVS