Subject | Re: [IBO] re: is 0.208 some magic value ? |
---|---|
Author | Pirtea Calin |
Post date | 2002-04-05T09:51:12Z |
"Duilio Foschi"
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@...
>0.208.
> If I write 0.000 , 11 , 1.1 , 1.0 or any other number, I always get ...
>What version of everything?
> 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 ?
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@...