Subject | bcd currency rounding pb |
---|---|
Author | News Noos |
Post date | 2002-08-19T10:58:08Z |
Hello,
I've seen some bulletins on the subject rounding bcd fields, but can't
figure exactly what to do :
We have an application developed with D5, Firebird 1.0, IBX 5.03 sp1 and use
for all currency fields numeric(15, 3).
In a record we have a value of 10.125 which is displayed with currency =
True as 10.12 instead of 10.13 for classical windows app (excel, access).
With float field (numeric(18, 6) for instance) the rounding is ok.
Should we convert all our numeric fields to float fields (ie numeric(18,6)
or there is some patch that can be applied ?
Thank's for help
Olivier STEINBERG
I've seen some bulletins on the subject rounding bcd fields, but can't
figure exactly what to do :
We have an application developed with D5, Firebird 1.0, IBX 5.03 sp1 and use
for all currency fields numeric(15, 3).
In a record we have a value of 10.125 which is displayed with currency =
True as 10.12 instead of 10.13 for classical windows app (excel, access).
With float field (numeric(18, 6) for instance) the rounding is ok.
Should we convert all our numeric fields to float fields (ie numeric(18,6)
or there is some patch that can be applied ?
Thank's for help
Olivier STEINBERG