Subject | FB 2.1.3 Error: The result of an integer operation caused the most significant bit of the result to carry. |
---|---|
Author | Sofija Blazevski |
Post date | 2009-11-26T16:20:06Z |
Hello,
I'm not sure why do I get this message "The result of an integer
operation caused the most significant bit of the result to carry."
I'm using FB 2.1.3
This is the line that raises exception:
V_DIFF = - V_AMOUNT * V_SIGN * V_RATE;
These are declarations
declare variable v_sign numeric(18,2);
declare variable v_diff numeric(18,2);
declare variable v_rate numeric(18,10);
declare variable v_amount numeric(18,2);
Using
CAST((V_AMOUNT * V_SIGN * V_RATE) as numeric(18,2)
doesn't help
I'm not sure why do I get this message "The result of an integer
operation caused the most significant bit of the result to carry."
I'm using FB 2.1.3
This is the line that raises exception:
V_DIFF = - V_AMOUNT * V_SIGN * V_RATE;
These are declarations
declare variable v_sign numeric(18,2);
declare variable v_diff numeric(18,2);
declare variable v_rate numeric(18,10);
declare variable v_amount numeric(18,2);
Using
CAST((V_AMOUNT * V_SIGN * V_RATE) as numeric(18,2)
doesn't help