How to change a field's data type?

Posted by Admin on 22-Feb-2012 09:36

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

All Replies

Posted by gus on 22-Feb-2012 10:08

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.

Posted by Thomas Mercer-Hursh on 22-Feb-2012 11:03

Or, rename, add, copy, and delete.

This thread is closed