Skip to main content
Answer

How to change size of a nvarchar DAC field in an existing screen ?

  • April 12, 2023
  • 4 replies
  • 288 views

Forum|alt.badge.img

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

Hi @oshadarodrigo64 ,

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

4 replies

Forum|alt.badge.img+9
  • Semi-Pro III
  • Answer
  • April 12, 2023

Hi @oshadarodrigo64 ,

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


Forum|alt.badge.img

Thank you for the reply @sweta68 !


Forum|alt.badge.img+1
  • Pro I
  • April 13, 2023

@oshadarodrigo64 yes you can change the length of custom field in existing screen.In the project editor for that field we can customize attributes and change the length.


Yuriy Zaletskyy
Jr Varsity I
Forum|alt.badge.img+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