DELETE and DELETEALL in D365 BC

DELETE and DELETEALL in D365 BC:

(1) Introduction: When records are deleted in the tables via “AL” then the DELETE method is used. Note: recommended to delete any record in the table, specify filters on that record using “GET” or “SETRANGE” & “SETFILTER” for getting the records which you want to delete.

(2) Syntax: DELETE.

[Ok :=] Record.DELETE([RunTrigger])

(3) In the below example, the Sales order document is deleted, using the DELETE and DELETE(TRUE) method as shown.

DELETE and DELETE(TRUE) method in business central

(4) Introduction: If you delete a set of records in one go, then the DELETEALL method is used.

(5) Syntax: DELETEALL.

Record.DeleteAll([RunTrigger])
DeleteAll method in dynamics 365

(6) There is another way to delete a set of records in one go by using the “DELETE” method with REPEAT UNTIL loop as shown.

DELTE method with REPEAT UNTIL loop in business central

MODIFY and MODIFYALL in D365 BC
INSERT and INSERT(TRUE) in D365 BC
How to add field in existing Table using extension In D365 BC
How to Attach MDF file Without LDF File by using SSMS
Getting Started with AL– Microsoft Docs

Leave a Reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock