Post reply

UPDATE is not allowed because the statement updates view "View_Test" which participates in a join and has an INSTEAD OF UPDATE trigger.

  • March 2, 2007 at 4:11 am

    #177042

    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.

  • March 2, 2007 at 9:24 am

    #692878

    There is no work around in 2005 because JOINS are idempotent that is they are not updatable per ANSI SQL and the same goes for view for more than one table.  The only option is partitioned view but your tables must be explicitly UNION compatible, run a search for partitioned view in the BOL(books online).  Hope this helps.

     

    Kind regards,
    Gift Peddie

  • March 6, 2007 at 7:35 am

    #693304

    Thanks,

    I will try that...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply