Subject Converting numeric types
Author Cao Ancoinc
Hi all

I have converted a field type from numeric(15,2) to numeric(15,4)

However, whenever data is inserted or updated in these fields, they are
always rounded to
2 decimal positions yet the table metatdata reflects the fields as being
Numeric(15,4)

Adding a new field works fine.

It seems that I will need to drop the fields and recreate them but I would
like to clarify
if it is not possible to change the precision and scale of existing numeric
field types.

Regards Cao