Subject | Re: assign same trigger to different tables |
---|---|
Author | godefcha |
Post date | 2002-03-07T11:43:57Z |
>it from
> Have you tried having that logic in a stored procedure and calling
> the triggers for the different tables? As per documentation, youcan 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)