automagically regenerate the triggers for a view when the view is regenerated

Userlevel 2
Badge +4

We have several VIEWs with a trigger attached.
Everytime we add a column to the view or make a small change to the internal query we need to manually remember to also regenerate the triggers for that VIEW.
Is there a way to automate that? 

An error like the ones the user get when a DEFAULT or LAYOUT isn't regenerated would also help a lot. Currently the trigger is just missing causing seemingly mysterious things to happen (the mystery is mostly why they do not happen).


Best answer by Erwin Ekkel 18 May 2022, 11:07

View original

This topic has been closed for comments

2 replies

Userlevel 6
Badge +16

Currently there is no solution for this. I have created an idea for this in the past feel free to vote there:



Userlevel 7
Badge +21

Current way around it is using the Code overview screen and executing your code from there. But in there you cannot alter templates. Erwin's suggestion is a good one.