Skip to main content
Answer

Why does increasing the column length cause this error?

  • December 16, 2024
  • 2 replies
  • 59 views

Forum|alt.badge.img+1

Initially, the UsrAddItemDescription field was created as PXDBString(500). Now, it needs to be increased to a length of 4000 characters. I modified the field definition accordingly, as shown below, and published the customization project.

As the next step, when I attempted to increase the column length using the database scripts below, the following error occurred.

Could I get any suggestions on how to resolve this issue?

Best answer by darylbowman

I believe you need to remove the field from the list behind the dialog. In your screenshot, you can see it still present.

Keep in mind that if you publish this in a place where the original field doesn't already exist in the database, it may not get created.

An alternative is to remove the original field from the list, add it with the same name but new length, and then add a separate database script to change the length.

2 replies

darylbowman
Captain II
Forum|alt.badge.img+15
  • Answer
  • December 17, 2024

I believe you need to remove the field from the list behind the dialog. In your screenshot, you can see it still present.

Keep in mind that if you publish this in a place where the original field doesn't already exist in the database, it may not get created.

An alternative is to remove the original field from the list, add it with the same name but new length, and then add a separate database script to change the length.


Forum|alt.badge.img+1

Thank you so much ​@darylbowman for your valuable answer.