try using DOUBLE PRECISION instead of NUMERIC. I had a similar problem with
STORED PROCEDURES that ALWAY rounded the values declared as NUMERIC or
DECIMAL. With DOUBLE PRECISION it goes fine!

Diego Menin
DBA - DM2/Brasil
www.cartonline.com.br

----- Original Message -----
From: "Greg Kay" <gkay@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, July 23, 2003 3:25 AM
Subject: [firebird-support] Numeric Rounding Error


> 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
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>