Subject Re: [IBO] re: is 0.208 some magic value ?
Author Pirtea Calin
"Duilio Foschi"
>
> 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 ?

What version of everything?

I tried this thingie myself and it works all OK.
I think you have some code that overrides your input value.
(Or maybe some triggers as Luiz sugested)

HTH

--
Best regards,
Application Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@...