Scenario:
Rename many customer names.Solution:
If the table has many relations, it will take a long time to rename through the record information one by one. We can use the table method renamePrimaryKey() in a batch class and run in batch mode.CustTable custTable;
ttsBegin;
select firstOnly custTable
where custTable.AccountNum == 'XXXX-WC-00002';
if (custTable)
{
custTable.AccountNum = 'XXXX-WC-00001';
custTable.renamePrimaryKey();
}
ttsCommit;
Authentic content..very knowledgeable.. thanks for this post.
ReplyDeleteTally on Cloud Server
Tally on AWS
Thanks for this blog keep sharing your thoughts like this...
ReplyDeleteMVC Training in Chennai
React JS Training in Chennai
Thanks for your excellent content, keep sharing.
ReplyDeletePHP Training in Chennai
PHP Certification Online
PHP Training in Bangalore
Great post! This explanation on renaming the primary key in D365FO is really helpful and clearly written. It made the whole process much easier to understand.
ReplyDeleteAlso, for anyone looking to expand their cloud skills, check out this AWS Cloud Course – it’s a great resource to get started with AWS.