web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Increase field length

(0) ShareShare
ReportReport
Posted on by 6

Dear All,

How to change the size of field in ax 2012?

Regards,

Work

*This post is locked for comments

  • Suggested answer
    Mahmoud Hakim Profile Picture
    17,887 on at

    you can see this picture

    24225.2.png

    for EDT , you need to change the size for EDT

  • neethukbabu Profile Picture
    6 on at

    Hi Hakim,

    The string size is associated with Extended Data Types and I tried to change it in the EDT. But it is throwing some error.

    Is there any other solution?

    Regards,

    Work

  • Mahmoud Hakim Profile Picture
    17,887 on at

    can you share screen shoot from error

  • neethukbabu Profile Picture
    6 on at

    Dear All,

    Sorry for the delay in reply.

    Please Find Attached Below.

    4628.Error.jpg

    Regards,

    Work

  • Sebastian Mankowski Profile Picture
    305 on at

    Did you synchronize database after changing size of EDT? If not... please do it - I believe it will help.

    Best

    Sebastian

  • neethukbabu Profile Picture
    6 on at

    Hi Sebastian,

    Yes I have done synchronize also.. But no luck.

    Any other option?

    Regards,

    Work

  • Sebastian Mankowski Profile Picture
    305 on at

    When exactly the error is thrown? Are you trying to open up the specific form?

  • Grzegorz Skrzypczyk Profile Picture
    225 on at

    Can you please say which EDT you changed?

    Did you recompile the application after the change?

  • neethukbabu Profile Picture
    6 on at

    Hi,

    I will explain in detail.

    I have one field named "Customer Reference" in SalesTable and its EDT is custRef(custRef has 60 stringsize).

    So i checked custRef EDT. This extends personName and has stringsize of 60,again i checked PersonName EDT and this extends Name EDT. Finally i reached to Name with string size of 60. I tried to change stringsize of Name EDT,because that is the base. But after changing this, nothing was working properly. So i thought to create new EDT and attach it to Customer Reference field, that also not working. after changing that when i open 'All sales orders' from Sales and Marketing module,the above error is getting. So i reset it to previous one and now it is opening properly.

    I tried to change it in the database also using alter table option, that also throwing error. some privilege issues.

    I have done synchronization compilation everything.

    I just would like to know, if any other solutions for this.

    Regards,

    Work

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans