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?