Subject Re: assign same trigger to different tables
Author godefcha
>
> 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.
>

The logic is already stored in a separate SP.
What could be interesting is if a procedure can be called with
implicit parameters avoiding to pass it all the NEW.fields that must
be managed.

The problem now is that I have to create plenty of triggers executing
exactly the same SQL code but differing only by the table they are
assigned to.


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