At 07:20 PM 2/04/2008, you wrote: >Hi Hellen, > > >> >> In Firebird 2 and higher you will get this exception if you have an >> AFTER trigger that attempts to update a column in the table that owns >> the trigger. > >That table have 5 triggers, 3 for Before Insert, 1 for Before Delete and 1 >for Before Update. >If I deactivate trigger from Before Delete it works!
Then your Before Delete trigger probably has a reference to NEW.something. It is invalid in a delete trigger. >It's strange because I have 1 trigger for each operation with the same >definition (inserting into a log table some values and operation type as "U" >for update, "I" for insert,etc),the difference is the type of operation! See above. You can only refer to OLD.something in a delete trigger. Helen ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
