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) / upgrade an existing SQ...
Microsoft Dynamics GP (Archived)

upgrade an existing SQL table using Dexterity

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have created a small add-in for GP using dex with a few tables.  Recently, I made some changes to this add-in, as well as added a new column to one of the table definitions. 

When i install the new .cnk file i get a sql error stating that the table definition doesn't match. I know why I am getting this error (the new column) but i don't know  how to upgrade the table definition via code rather than drop and recreate the table.  I looked at an example of a table conversion on Customer Source but that seems really extensive for just adding a column to a table.  Can anyone point me in the right direction here to a blog post or other form of example?

Thanks,

Aaron

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: upgrade an existing SQL table using Dexterity

    I believe you are going to have to transfer your data into a temp table, recreate the old table according to the new table definition and then import your data back in to the newly remodeled table. Adding a column to the table changes the record length.

  • Community Member Profile Picture
    Community Member on at
    Re: upgrade an existing SQL table using Dexterity

    There are dexterity sample applications available for it at patnersource. You can download them from here

    mbs.microsoft.com/.../sampleapplicationsfordexterity10.htm

    SQL Table Conversion Example has upgrade table related code

  • Community Member Profile Picture
    Community Member on at
    Re: upgrade an existing SQL table using Dexterity

    Thank you for your replies Leslie and Rubal,

    Unfortunately, I do not have access to Partner Source as I am a customer.  Leslie, do you happen to know where I can find some examples of what you are referring to?  I understand the concept you are outlining, but I am still learning Dexterity and I want a little help to get started.  Is the table conversion example on Customer Source the only example I have to go on here?

    Thanks,

    Aaron

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