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

Question

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).

Erwin Ekkel · Accepted Answer

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

Mark Jongeling · Answer

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.

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded