I am using an insert trigger to store or update the values of second table while inserted in the first table by performing some calculations. For update operation also i need to update some columns in the second table. But while updating i am getting the following error. The error message is as follows:
"The row value(s) updated of deleted either do not make the row unique or they alter multiple rows(5 rows)".
Please provide a solution for this.
asked Feb 15, 2010 at 02:34 AM in Default
Make sure you are using the correct WHERE clause on the second table, that is, the WHERE clause has to contain the columns for the primary key/unique index.
Personally I try to avoid triggers because of the performance impact, I try to build this kind of logic in stored procedures and prevent direct access to the tables. All data access is done through stored procedures.
answered Feb 15, 2010 at 04:36 AM
answered Feb 15, 2010 at 10:59 AM