Subject | RE: [firebird-support] DML in triggers |
---|---|
Author | Leyne, Sean |
Post date | 2007-01-31T00:04:58Z |
Chris,
details for this issue are important
Please confirm the FB version/platforms you are running.
Please post the code to the problematic trigger.
Sean
> I had a Before Update trigger that included a statement like:Is
> 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).
> this possible, and if so, how can I implement it?Nothing you should do in the database should cause a corruption, so the
details for this issue are important
Please confirm the FB version/platforms you are running.
Please post the code to the problematic trigger.
Sean