Function “OnAfterOnDatabaseDelete” from the codeunit 1 ApplicationManagement

Loufus

Hello everyone
I am using the function “OnAfterOnDatabaseDelete” from the codeunit 1 ApplicationManagement to record the deletions that happened from the database



I am not recording every single deletions, I am actually using a setup table that contains the tables I need to record
However, the problem is that this function only catches the deletion that happen from standard tables (such as Sales Header, Customer …) but it does not catch those that happen from custom tables.
Any idea how I can make it work for custom tables
Thanks in advance.

Duikmeester

Make a GetDatabaseTableTriggerSetup subscriber and set OnDatabaseDelete parameter TRUE for all your tables. Don't set any FALSE or else you influence standard functionality.

Duikmeester

Make a GetDatabaseTableTriggerSetup subscriber and set OnDatabaseDelete parameter TRUE for all your tables. Don't set any FALSE or else you influence standard functionality.

Loufus

Thanks a lot that seems to be working

robbonick

Could you not just use Change Log Entries to track the deletes from the tables you require?

Duikmeester

@robbonick that would cause the Change Log Entries to flood with info you would like to use otherwise.

robbonick

Yeah I guess if you are tracking Modifications, Inserts and Deletes for the given table. I guess I was just trying to offer an option which requires no code changes. Of course I understand there are instances where this is not a viable option.