Subject RE: [firebird-support] Debugging cascaded updates
Author Alan McDonald
> I need some suggestions here. I have a table whose primary key is the
> foreign key in a number of other tables (about 30 or so). When I try
> to delete a record from this table, I get a funny error message,
> because one of the tables that relies on it has a bug in a before or
> after delete trigger.
>
> The other tables are all defined as "on delete cascade".
>
> Is there any quick and easy way of finding which trigger is throwing
> the error message, or is process of elimination the only way?
>
> Thanks for your help
>
> Adam

how are you deleting the record? in something like IBExpert? or another
tool?
what's the funny error message?
Alan