Subject | DML in triggers |
---|---|
Author | Chris Wallis |
Post date | 2007-01-30T23:23:01Z |
I had a Before Update trigger that included a statement like:
delete from ATable where SomeField=Somevalue
embedded in a trigger on ATable. This was causing the database to be
corrupted. In other tables, I'ved used triggers to update other tables with
great success. I need to re-create the delete functionality described above,
and I can do it at the application level, but I would prefer that the
function is part of the database logic (i.e. application-independent). Is
this possible, and if so, how can I implement it?
delete from ATable where SomeField=Somevalue
embedded in a trigger on ATable. This was causing the database to be
corrupted. In other tables, I'ved used triggers to update other tables with
great success. I need to re-create the delete functionality described above,
and I can do it at the application level, but I would prefer that the
function is part of the database logic (i.e. application-independent). Is
this possible, and if so, how can I implement it?