3,027
Hi
I have table1 , Key Location Code,Date. I want before insert if record already exists then it should not Insert.
IF TEntry.FINDFIRST THEN BEGIN
TeDate := TEntry.Date;
Amount := 0;
REPEAT
Amount += TEntry."Amount";
IF TeDate <> TEntry.Date THEN BEGIN
CNLine.VALIDATE("Store No.","No.");
CNLine.VALIDATE("Date",TEntry.Date);
CNLine.VALIDATE("Amount",TEntry."Amount");
CNLine.INSERT;
TeDate := TEntry.Date;
Amount := 0;
END;
UNTIL TEntry.NEXT=0;
END;
*This post is locked for comments
Hi
Closed. Logic was wrong
Thanks
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...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (