Decrease field lenght

[former_member414470]

Hi ALL,

I need to change a field type DEC 13,5 to DEC 15,12. But I received an error message - Length change - ALTER TABLE is not possible.

Does anyone has a solution for that? Do I have to save data into a temporary table and then make the change?

Best regards, please help me!!

[Former Member]

Hi,

After changing the length of the filed you need to adjust the database table.

Use the menu path Utilities->database objects->Database Utility.

Select the save data radio button and press the Activate and adjust database pushbutton.

[former_member414470]

Thanks a lot Avinash Kodarapu,

We had changed the table.

Best regards

José Alves