2 Replies Latest reply on Dec 1, 2004 7:21 PM by 429125

    AFTER INSERT OR UPDATE TRIGGER

    429125
      All of my tables have a dateTime field which is used to track when a record was inserted/updated. I would like a trigger on each table that updates the dateTime field with the current date and time after each insert or update. I keep getting a mutating error and I can't quit wrap my brain around how to fix it. Could anyone provide a example.

      I know I am getting the error because I am trying to update the row that is currently being inserted or updated - what is the best way to handle this?

      Thanks