It appears that you can create a trigger on a view within TaskCentre but this is not true. It does not work they way you might think or expect. There is an INSTEAD OF triggering action on SQL views that is better described here.
For TaskCentre purposes you will want to always base your task on a table INSERT or UPDATE. I spent a number of hours trying to figure out how to use a view with no success.
I am simply not satisfied with this. What about creating a view that updates a table periodically? I am off to try out the theory...
1 comment:
As far as I know, you can create a Trigger on a view, but for the trigger to actually fire the task, the update (or create) must be done through that view as oppose to via (one of) the underlying table(s).
View triggers will always be "instead of".
Did you get anywhere with more testing?
Post a Comment