Subject | Trigger on child table isnt activated when i delete the parent table? cascade |
---|---|
Author | Fabio Gomes |
Post date | 2006-11-09T13:25:55Z |
Hi guys,
I have 2 tables and i set the relationship between them to cascade, and i
have a trigger on the child table to delete some stuff on other table, when
i delete the row in the child table it works, but when i delete the parent
(and the cascade option deletes the child table rows too) this trigger isnt
activated.
Does firebird always behave this way? there is a way to activade this
trigger when deleting the parent table or i ll have to create a trigger on
the parent table?
thanx for any help.
-fábio
[Non-text portions of this message have been removed]
I have 2 tables and i set the relationship between them to cascade, and i
have a trigger on the child table to delete some stuff on other table, when
i delete the row in the child table it works, but when i delete the parent
(and the cascade option deletes the child table rows too) this trigger isnt
activated.
Does firebird always behave this way? there is a way to activade this
trigger when deleting the parent table or i ll have to create a trigger on
the parent table?
thanx for any help.
-fábio
[Non-text portions of this message have been removed]