Subject Re: [IBO] Still Formatting problems
Author Svein Erling Tysvær
Lee,
I think this behaviour is correct for a floating point field. You set the
display to 2 digits after the decimal point, but when you are editing you
generally want to edit the exact value. If you want the field to contain a
specific number of digits after the decimal point, then using a floating
point field is not appropriate. Follow Jasons and Luiz advice and use a
scaled numeric.

Set

>I have a floating point field.
>I use a TIB_Edit component to display and input data.
>I want the users to see and enter data with maximum two digits after
>the decimal point.
>The display part I can manage using
>IB_Query.Fieldsdisplayformat '#,###,##0.00'
>But when the user tabs into the IB_Edit component the display goes
>from 15.45 to 15.4499998092651
>when the user tabs out of the IB_Edit the display goes back to 15.45
>how do I fix this ?
>If I have to use a mask, how do I do that, and what is the mask ?