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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / ANSI_PADDING off
Microsoft Dynamics GP (Archived)

ANSI_PADDING off

(0) ShareShare
ReportReport
Posted on by Lee Boon Chong 2,040

I'd like to change the table column length size using the SQL enterprise manager - design table, while I click save it pop up validation warnings

- Warning: One or more existing columns have ANSI_PADDING 'off' and will be re-created with ANSI_PADDING 'on'.

- Warning: The table was created with ANSI_NULLS 'off' and will be re-created with ANSI_NULLS 'on'.

what does it mean? what should I do?

 

 

 

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: ANSI_PADDING off

    Hi Lee,

    You should not change the table column length using any tool. If you do, the next time Dynamics attempts to access the table it will throw a 'record length' error and the application will not continue in a satisfactory manner.

    Dynamics expects the table to remain exactly the same as was created. You can add indexes without  crashing the system, but that is all.

    Kind regards,

    Leslie

  • Lee Boon Chong Profile Picture
    Lee Boon Chong 2,040 on at
    Re: ANSI_PADDING off

    Hi Leslie,

    Any other way to change the column length without crashing the system?

    Thanks.

    Lee

  • Community Member Profile Picture
    Community Member on at
    Re: ANSI_PADDING off

    Hi Lee,

    Changing the column size in SQL will not increase the size of the field in GP.  What are you trying to accomplish?

    Thanks,

    Bradley

  • Lee Boon Chong Profile Picture
    Lee Boon Chong 2,040 on at
    Re: ANSI_PADDING off

    Hi Bradley,

    The column size existing now is not enough to let me key in all the word that I need.

    Thanks.

    Lee

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: ANSI_PADDING off

    Use Extender.  Extender will let you create additional fields (not extend the current fields) but the new fields can be larger and can keep the data you need.

    There are two versions.  The MS Extender allows the creation of windows (and forms and inquiries, etc) while the eOne eXtender does all of that plus allows the inclusion of logic associated with the windows/forms.  Both are the same product, the eOne is an expanded version.

    Contact your partner for information on costs.  It can be installed in a matter of hours.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: ANSI_PADDING off

    Lee,

    There are a couple of methods depending on modules you own and which field it is. Of course, Extender is the sweetest option, but not always desireable because the user interface is so different. So, do you have access to Modifier? You could put a user-defined string field on the window and then save it to the duos tables. I feel certain that David Musgrave has an example of this on his blog.

    What field do you need to be longer? How long?

    Leslie

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans