Post reply

Update doesn''t Update

  • April 17, 2007 at 10:56 am

    #116710

    Hi all.  Just wondering why my actual update doesn't fire an update. I think it is because nothing in the row has changed but I am wondering why.  Here is an example.

    I call this update to update all of the rows in the table like this

    UPDATE (table_name)

    SET actv_stat = 1

    All of the rows in the table already have an actv_stat = 1 but the message that I get back says 3000 rows affected but the table actually isn't affected.

    Oh also there is a instead of update trigger on the table too.

    Thanks

     

     

  • April 17, 2007 at 11:30 am

    #700973

    2 questions for you:

    1. You say that the message says that 3000 rows were affected but that the table is not affected.  If you are updating the row to the exact same value, how can you say that nothing was affected?  What were you expecting?

    2. What is your instead of update trigger doing?

     

    PS - OK, so this is more than 2 questions.....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • April 17, 2007 at 12:03 pm

    #700989

    But good questions.

  • April 17, 2007 at 12:59 pm

    #701003

    Actually, there is an audit trigger that updates a row_eff_date field whenever something is updated and it wasn't reflecting that 3000 rows had been updated.

    But on a different note, I should have looked into this a little more before posting because I discovered that it was my Instead Of Update Trigger that was actually preventing the rows from being updated. 

     

    thanks

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

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