| Subject | Re: [ib-support] How to handle money fields |
|---|---|
| Author | adragan2 |
| Post date | 2005-12-20T19:34:54Z |
That's some issue.
I solved the problem by using Cast( <your value > as Numeric(16,2))
See that you don't go over the values.
For banking issues try working with 4 decimal points.
Cast( ....... as Numeric(16,4))
It seems the truncation errors are neglijable.
The solution is not perfect but works in most of the cases.
I solved the problem by using Cast( <your value > as Numeric(16,2))
See that you don't go over the values.
For banking issues try working with 4 decimal points.
Cast( ....... as Numeric(16,4))
It seems the truncation errors are neglijable.
The solution is not perfect but works in most of the cases.