I took your advice and made a domain with numeric(12,2)
B.T.W. I work with QuickDesk
When I change the floating-point field in QuickDesk to this domain I
get the following error

unsuccessful metadata update.
Cannot change datatype for EP_VAT. Conversion from base type DOUBLE
PRECISION to 64-bit numeric is not supported.

When I change the floating-point field directly, not with a domain It
works, but instead of changing to a Numeric(12,2) field it changes to
a double-precision field.

Is there a way to change a field from floating-point to numeric
(12,2) ?


--- In IBObjects@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> 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 ?