Subject Numeric Rounding Error
Author Greg Kay
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