Re: Mutating Trigger...More thoughts [message #36483] |
Thu, 29 November 2001 07:37 |
Susan
Messages: 102 Registered: October 2001
|
Senior Member |
|
|
Table B is a constraining table which means that the table might need to be read from for a referential integrity constraint. SQL statements in a trigger body may not read from or modify the primary, unique or foreign key columns of a constraining table. Usually, the solution is to create 2 triggers a row and a statement level. See Ask Tom link for more info.
----------------------------------------------------------------------
|
|
|