Hello Helen.

The first time it happened, I was using a 'numeric(11,2)' field. I
changed the precision and it did not change anything. So I changed
it to double precision because I thought it was a precision problem.

Just to be sure, I did what you told in your post. I defined a
numeric(11,4) field. I entered 25142356.23 in the field. Look at
the result: 2514E7. Same with a numeric(11,2) and numeric(14,2) and
numeric(18,4).

Anyway, if it's what you think it is, I would have the same behaviour
in TIBOQuery, but I don't. In TIBOQuery, it's Ok. And it's Ok with
all these different field definitions.

I think the problem is of another kind.

Thanks for the help.


Jocelyn Dionne.

--- In IBObjects@y..., Helen Borrie <helebor@w...> wrote:
> 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
> >annoying.
>
> 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.
>
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________