Re: Trigger problem

You don't supply the full code for your trigger, so forgive me if I'm stating the obvious, but...

Is the trigger defined as "before update on <table>", or "before update on <table> for each row". The first type of trigger only fires once, regardless of how many rows are being updated. The second type of trigger fires once for each row updated. Received on Sat Jun 08 1996 - 00:00:00 CEST