How to Change the Data Type of a UD Column

Kinetic ERP
1

I have a UD column on a table that already has data entered for it, and I’d like to change the data type from Integer to Long.

The UD Column Maintenance screen does not allow you to change the data type after it is added.

Is there a backdoor way of doing this? I’m thinking altering the column with an SQL script and modifying the Ice.ZDataField record might work, but I don’t know if that will have any undue side effects.

Does anyone have any thoughts on this?

2

Unfortunately, you have to delete the column, regen, add the column back, regen.

Id export the column data to excel, then dmt the data back in after the column is recreated.

3 Likes