Subject RE: [ib-support] Rounding Problems
Author Leyne, Sean

What version of Interbase are you using?


-----Original Message-----
From: Marcos Vinicius Dufloth [mailto:dufloth@...]
Sent: Monday, May 14, 2001 3:34 PM
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?