Hello Experts
This is more of a request for an opinion
Is it advisable (or sensible even) to run processes off the back of custom read only views? From a technical perspective, I am able to generate an Update event on a view, however it seems a bit nonsensical as well since by very definition the view is a read-only object (hence no updates). Having said that, looking at it another way, it is possible to have an update on a view (if a proper primary key is defined on it) if the underlying data changes in one of the tables the view is based on. Same for Insert I guess.
Curious to have your opinions on it - should events be used on custom read only views?
Thanks
Kin
PS: v8.0 here