At 05/04/2002 05:31 AM, you wrote:

>--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
>
> >0 is not an exact value for a numeric(9,3); 0.000 is.
>
>Helen,
>
>If I write 0.000 , 11 , 1.1 , 1.0 or any other number, I always get ... 0.208.
>
>If I replace the TIBOQuery with a TIBOTable, I get the same results.
>
>If I update the field from SQL, ev works ok.
>
>If I change the field format into numeric(9), ev works ok.
>
>If I change the field format into numeric(9,1), I always get ... 0.2 !
>
>If I change the field format into numeric(9,5), ev works ok !
>
>If I go back to the numeric(9,3) field format, I get ... 0.208 !
>
>Can you explain this mystery ?

Did you do a search in your code for this value? Can it be that you have
an event attached to a persistent field? If you don't have the same
behavior when working directly with the DB, then it must be something in
your code. Also, I don't get that kind of behavior with mine and I use
TIBOQuery and TIBOTable.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)