Hello everyone,
I have created some custom tables and pages in Business Central Sandbox to achieve a particular functionality. After I have ran the code, the extension is now installed in business central. The problem I am facing is that, when I'm now changing any table's primary it is giving me an error that "we cannot update the extension because of 'Table 50100 Purchase Requisition Header :: Changing fields for the key 'PK' is not allowed". I tried forcesync but it is not working in my case and I cannot delete the extension because I contains a lot of data. Kindly help. Thankyou
Hi, just adding some info, hope this helps as well.
In-depth testing for Force Sync mode in Production Environment (Renaming tables, Renaming fields, Changing field type…)
Developers can write faster upgrade code (New DataTransfer data type)
Thanks.
ZHU
Hey mohana, is there any example of this?
you have to create new table with updated key and write upgrade codeunit to move the data from first table to new table
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156