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