Subject Re: [firebird-support] Assign Double Precision value to a varchar field in Stored Procedure
Author Tomasz Tyrakowski
On 2012-03-21 09:25, Ivy wrote:
> [...]
> MoneyInStr = myMoney;
> I store this value into a table and found that this value eventually appears as -2E-6.

And where exactly it appears as -2E-6 and how do you know it's not the
tool that you use to check the value that does the rounding?

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

I think it actually does. Try to select from the table only the records
that have the field (the one you stored the calculated value in) between
-0.00000199868556 and -0.00000199868554. If you get a record back, it
proves your conclusion wrong.
But please, use a tool as generic as possible (I'd suggest isql), i.e.
one that won't round your -0.00000199868556 and -0.00000199868554 to
-2E-6 ;)


__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== ==--__