Skip to main content
Solved

Why does increasing the column length cause this error?

  • December 16, 2024
  • 2 replies
  • 38 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.

View original
Did this topic help you find an answer to your question?

2 replies

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1702 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings