Post reply

Trigger updating a field value of the updated reco

  • October 30, 2001 at 9:12 am

    #157586

    I'm trying to create a trigger that fires on update from a table.

    That would updated one column of the updated record.

    ex: On UPDATE the table OPERATIONS the trigger should update the value of the column UPDATES for the record that was just updated (with a where condition or someting like that)

    Is this possible?

  • October 30, 2001 at 10:45 am

    #419503

    Yes. You just use the inserted table to qualify which rows you want to update.

    Andy

    Andy
    Connect with me on LinkedIn

  • October 30, 2001 at 12:36 pm

    #419506

    You can also use UPDATED() to check if a specific column has changed.

    Steve Jones

    steve@dkranch.net

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

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