Subject Re: [IBO] Re: Problem in TIB_Query and currency...
Author Helen Borrie
At 07:00 PM 06-02-01 +0000, you wrote:
>Hello Jason.
>If I use TIBOQuery, I don't have this problem, small numbers or big
>ones. So, I think it's not the problem. Maybe I don't understand
>what you mean.
>Do you think about some actions that I can take to solve the problem?
> >From now on, I don't specify any field 'currency', and I use the
>OnGetDisplayText event to format the numbers. But, I find it very

I think part of your problem is using Double for money values. You are
observing precision errors because of it. Use Numeric(11,4) or better and
your storage and formatting problems should go away.


All for Open and Open for All
InterBase Developer Initiative ยท