Using Table Trigger events on table extensions

(0) Share

Report

Posted on by Andrea Antolini

Hi to all,

There are actually two ways of writing a table trigger Event in VS Code:

1) Creating a Codeunit and subscribing to the event (OnBeforeValidateEvent,OnAfterValidateEvent,etc)

2) Creating a Table extension, modifying the standard field and writing code on the trigger "OnAfterValidate" of the field

As the two alternatives are, in a semantic way, totally identic, is there a difference in terms of performance or other aspects that I do not see in the first place?

Thanks in advance for your suggestions,

Andrea Antolini

Categories:

Other

All responses (1)

Answers (0)

Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (1)

Report

RE: Using Table Trigger events on table extensions

Performances: no.

Normally I prefer the second way. In your custom table, you should write code in the OnValidate trigger of the field (the tabkle is yours).

In a custom table, a tableextension creates an object on the underlying database that can be unuseful for handling only code in an event. I prefer the usage of the event-based programming, so a codeunit with an event subscriber.