Skip to main content
Solved

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


Forum|alt.badge.img+6

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

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

 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Forum|alt.badge.img+17
  • Moderator
  • 761 replies
  • Answer
  • May 18, 2022

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

 

 


Mark Jongeling
Administrator
Forum|alt.badge.img+23

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings