How to change a field's data type? - Forum - OpenEdge RDBMS - Progress Community

How to change a field's data type?

 Forum

How to change a field's data type?

  • Hello,

    I would like to convert my Integer field into Decimal.

    How can I do this?

    Do I have to delete my field?

    Thank you

  • 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