Triggers giving problems--help urgently

• Vyom

  SSC Journeyman

  Points: 77

  More actions

  March 30, 2005 at 11:18 am

  #164152

  hello everyone,

  Well i tried an after trigger for populating some columns in a table which requires values from various tables..the values are being populated correctly but still gettin some error--"Row cannot be located for updating. Data might have changed since last read."

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  March 30, 2005 at 1:00 pm

  #549638

  Try surrounding your updates with BEGIN TRANSACTION... COMMIT TRANSACTION and that may block the row for the Trigger to work...

  I wasn't born stupid - I had to study.