topic Re: Decrease field lenght in Application Development and Automation Discussions

Decrease field lenght

former_member414470 — Thu, 22 Jan 2009 14:39:27 GMT

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 — Thu, 22 Jan 2009 14:45:34 GMT

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 — Thu, 22 Jan 2009 20:20:52 GMT

Thanks a lot Avinash Kodarapu,

We had changed the table.

Best regards

José Alves