Subject | Numeric Rounding Error |
---|---|
Author | Greg Kay |
Post date | 2003-07-23T06:25:35Z |
Hi,
We have an intermittent problem with a NUMERIC(12,2) field occasionally
being incorrectly rounded. We are doing simple inserts like
"INSERT INTO MyTable (ID, F1, F2) Values(:ID, :F1, :F2)" with params
ID='IT02138733', F1=37732.67, F2=0
but the value in F1 is rounded to 37733 in the database. ID is CHAR(10)
and F1 and F2 are NUMERIC(12,2). This is not happening all the time and
cannot be routinely reproduced. We do probably a few hundred of these
inserts per day but only about 3 have this rounding error.
We're using Delphi with IBX and Firebird 1.02.
Greg
We have an intermittent problem with a NUMERIC(12,2) field occasionally
being incorrectly rounded. We are doing simple inserts like
"INSERT INTO MyTable (ID, F1, F2) Values(:ID, :F1, :F2)" with params
ID='IT02138733', F1=37732.67, F2=0
but the value in F1 is rounded to 37733 in the database. ID is CHAR(10)
and F1 and F2 are NUMERIC(12,2). This is not happening all the time and
cannot be routinely reproduced. We do probably a few hundred of these
inserts per day but only about 3 have this rounding error.
We're using Delphi with IBX and Firebird 1.02.
Greg