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).
Solved
automagically regenerate the triggers for a view when the view is regenerated
- Hero
Best answer by Erwin Ekkel
Currently there is no solution for this. I have created an idea for this in the past feel free to vote there:
This topic has been closed for replies.
Currently there is no solution for this. I have created an idea for this in the past feel free to vote there:
+23Current 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.