| Subject | Automatic Conversion from Numeric to Integer |
|---|---|
| Author | guido.klapperich@t-online.de |
| Post date | 2002-11-07T01:51:51Z |
I have a variable in a SP like this
declare variable Result Numeric(10,5);
and in the body of the SP I do the following calculation
Result=1/2;
The result is always 0, But when I do
Result=cast(1 as Numeric(10,5))/2
the result is 0.5
Exists a way to avoid the cast ? I'm using FB 1.0
Guido
declare variable Result Numeric(10,5);
and in the body of the SP I do the following calculation
Result=1/2;
The result is always 0, But when I do
Result=cast(1 as Numeric(10,5))/2
the result is 0.5
Exists a way to avoid the cast ? I'm using FB 1.0
Guido