Subject | RE: [ib-support] Rounding Problems |
---|---|
Author | Leyne, Sean |
Post date | 2001-05-14T19:32:46Z |
Marcos,
What version of Interbase are you using?
Sean
-----Original Message-----
From: Marcos Vinicius Dufloth [mailto:dufloth@...]
Sent: Monday, May 14, 2001 3:34 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Rounding Problems
Hi list.
I have a problem with numeric fields and rounding. In database, there is
a value stored in a numeric(15,4) field equals to 16.7200. Inside a
trigger, when this value is moved to a variable, also numeric(15,4), it
turns 16.7199999999989 causing some problems to me. I read that numeric
types have exactly N digits of precision. Whi this is happening?
Dufloth.
What version of Interbase are you using?
Sean
-----Original Message-----
From: Marcos Vinicius Dufloth [mailto:dufloth@...]
Sent: Monday, May 14, 2001 3:34 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Rounding Problems
Hi list.
I have a problem with numeric fields and rounding. In database, there is
a value stored in a numeric(15,4) field equals to 16.7200. Inside a
trigger, when this value is moved to a variable, also numeric(15,4), it
turns 16.7199999999989 causing some problems to me. I read that numeric
types have exactly N digits of precision. Whi this is happening?
Dufloth.