Hi there,
I have a single view on two tables with an "Instead of Insert" and an "Instead of UPDATE" Trigger.
When I try to update a record in the view directly it works perfect. But when I join the View with another table and then try to update a record I get the following error:
"UPDATE is not allowed because the statement updates view "View_Test" which participates in a join and has an INSTEAD OF UPDATE trigger."
Does anybody have any Idea what to do??? I need to update a few hundered records at a time.
Please help.