Hi,
I need to expand the size of a dac field in an existing screen. For example I need to change nvarchar(50) size into nvarchar(100). Is it possible to do this using customization project editor or is there any other way to do this? Can someone provide me the guidance please?
Thank you.
Best answer by sweta68
View originalHi
If you have a custom field on your existing screen, then this blog will help you.
https://www.greytrix.com/blogs/acumatica/2023/01/27/increase-column-length-in-acumatica/
Regards,
Sweta
Thank you for the reply
+3
To change the length, you need to add the PXDBString attribute and in a brackets specify the length whiсh you want. Also value of string lenght should be the same in code, SQL, and customization. If it's not it could be a data lost. Also you need change value in SQL table and than you need to press Reload from Database button in Database Scripts in your customization package
[PXDBString(100, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Description")]
public virtual string OrderDesc { get; set; }
public abstract class orderDesc :
PX.Data.BQL.BqlString.Field<orderDesc>
{ }To change value length using customization, you need to click Increase Column Length under Database Scripts and in the window select needed table, then the field and after that set the desired length
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.