Subject re: is 0.208 some magic value ?
Author Duilio Foschi
--- 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 ?

TIA

Duilio