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
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
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
Is there are way to get more precision from the ODBC
driver or am I missing a setting somewhere?
Thanks in advance,
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
pgsql-odbc by date
|Next:||From: Ryan C. Bonham||Date: 2001-08-20 20:02:55|
|Subject: RE: [ODBC] Re: Updating a view|
|Previous:||From: Johann Zuschlag||Date: 2001-08-20 15:25:11|
|Subject: Stackerror using new CVS|