Hi All,
Please note I need to find way to change customized field type int to decimal. Int type doesn’t allow to enter decimal values. I have tried by changing original attribute but it’s not saving either.
Solved
How to convert customized field type int to decimal using frontend
Best answer by Naveen Boga
Here is an example
ALTER TABLE table_name
ADD column_name datatype;
Ex:
ALTER TABLE SOOrder
ADD UsrTestFiele decimal(19,6);
+19If this package is already deployed in any instance then again you need to write a Alter script to modify the Type in the database in the Database scripts section.
Naveen B
+19Have you deployed the script to change the data type in the database?
Naveen B
+19Here is an example
ALTER TABLE table_name
ADD column_name datatype;
Ex:
ALTER TABLE SOOrder
ADD UsrTestFiele decimal(19,6);
Naveen B
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.