I would like to convert my Integer field into Decimal.
How can I do this?
Do I have to delete my field?
Sorry, but you cannot change the data type of an existing field.
You will have to delete it and add a new one. If you have existing data that you want to preserve, then you will have to write a program to save the values to a file before you delete the field. Then you will need another program to read the data back and update the records.
Or, rename, add, copy, and delete.
Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice http://www.cintegrity.com