Subject | Numeric rounding? |
---|---|
Author | sgharp |
Post date | 2005-01-04T18:43:25Z |
Hi All,
I have a table (FB 1.5) with a field defined as Numeric(12,4). I use
this field in a store procedure with a variable defined as
Numeric(12,2). When the field is selected into the variable it stores
something like 123.4567 in the defined variable instead of rounding it
to 123.46 as expected. Is there a way to make Firebird respect the
variable definition in the stored procedure and round the number
correctly?
Thanks,
Steve
I have a table (FB 1.5) with a field defined as Numeric(12,4). I use
this field in a store procedure with a variable defined as
Numeric(12,2). When the field is selected into the variable it stores
something like 123.4567 in the defined variable instead of rounding it
to 123.46 as expected. Is there a way to make Firebird respect the
variable definition in the stored procedure and round the number
correctly?
Thanks,
Steve