Skip site navigation (1) Skip section navigation (2)

Float Percision with MS Access 97

From: Michael Calabrese <m2calabr(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Float Percision with MS Access 97
Date: 2001-08-20 16:05:55
Message-ID: 20010820160555.71744.qmail@web10708.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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/

Responses

pgsql-odbc by date

Next:From: Ryan C. BonhamDate: 2001-08-20 20:02:55
Subject: RE: [ODBC] Re: Updating a view
Previous:From: Johann ZuschlagDate: 2001-08-20 15:25:11
Subject: Stackerror using new CVS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group