Subject Assign Double Precision value to a varchar field in Stored Procedure
Author Ivy
Dear Sir/Madam,

I am using Firebird 2.5 currently and I eventually face this kind of issue which I am not sure whether it is a bug of Firebird or the natural way of Firebird engine :-

1) I have a double precision variable ( e.g. myMoney ) which after some calculation, it ends up with figure -0.00000199868555.
2) When I want to assign this value to a varchar field ( e.g. MoneyInStr) , I do the below statement :-

MoneyInStr = myMoney;

I store this value into a table and found that this value eventually appears as -2E-6.

May I know why it won't get store as -0.00000199868555?


[Non-text portions of this message have been removed]