At 07/03/2002 06:15 AM, you wrote:

>As triggers can now be separated in multiple parts, I can separate the
>specific and common parts.
>
>What I would like to do (but do not know if it is possible) is to
>assign the 'common part trigger' to different tables.
>
>What I mean is something like
>
>CREATE TRIGGER TRIGNAME FOR TABLE1, TABLE2, TABLE3
>ACTIVE BEFORE INSERT POSITION 0
>...

Have you tried having that logic in a stored procedure and calling it from
the triggers for the different tables? As per documentation, you can only
use one table with CREATE TRIGGER.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)