Is it possible to change a Field Type from Decimal to Integer?

[richelle_pivec]

Is it possible to change a Field Type from Decimal to Integer? It does not appear to be a choice when I click on the magnifying glass next to the Type for an existing "decimal" field.

thanks,

Richelle

[Chandu Telu · Accepted solution]

Hi Richelle,

No, you can;t change the Field Type from Decimal to Integer it will through an error

[Chuck Tomasi]

While you can change from SOME field types to other field types, changing from Decimal to Integer is not one of them. They are not compatible data types at the database level. You would end up with garbled information.

The best option is to create a new column of integer type, then copy over the data from the decimal field. Once that is done, you can disable the decimal field or (if you prefer, which I don't) delete the decimal field.

[nakuldani]

Hi Chuck,

I had the same requirement and I did exactly what you said. Even I kept the column name same, however the scripts in which the column name is referred are not working for that particular field. what could be the reason and how should I overcome this issue?

Thanks.

[Nen]

Hi, Chuck! Is there a link or documentation where can I find the list of compatible data types?

I'm planning to change a field from Price to Decimal. Decimal is available on the "Type" lookup on the Dictionary Entry record so I'm assuming they're compatible. I've tried it and so far the data looks good but I just wanted to make sure I'm not going to end up with garbled information.

Thanks!