25
I created Source table and destination table .
1. Inserted records from source to destination using insert in codeunit
2.Now I changed Records in source Table I want to update the same using codeunit help me
I am getting this error:
The Insert Modify Task destination already exists. Identification fields and values: No.='101'
---------------------------
OK
---------------------------
Hi, It seems that the record already exists when you insert it again, please check before insert.
for example
if destination.get(PrimaryKey) then
exit;
Hope this will help.
Thanks.
ZHU
Hello,
You can either empty the destination table every time (DELETEALL;), and then re-insert every record from the source table. If you only want to update existing records in the destination table, then TRANSFERFIELDS and MODIFY should do it, like this, assuming that source and destination table definitions are identical:
DestinationTable.GET(SourceTable.PrimaryKey);
DestinationTable.TRANSFERFIELDS(SourceTable);
DestinationTable.MODIFY;
I hope you can use that?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (