Subject | Converting numeric types |
---|---|
Author | Cao Ancoinc |
Post date | 2005-03-29T11:10:38Z |
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
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