Re: Multiple Actions in TRIGGERS - syntax help?

Graeme Sargent (graeme@pyramid.com) wrote: : M. Stenzler (rpcg@panix.com) wrote: : : Anyone know the correct syntax to implement a trigger that : : performs multiple actions for a triggereing event? : : ... Enclose the entire block in parenthses, and comma-separate all but the last statement within, like the 1st example you cited. FOR EACH ROW ( do this thing, do another thing, ... do the last thing ); : ... : FOR EACH ROW (insert into t_2 values (...)), (insert into t_3 values (...)) If this indeed works, apparently the parens around the whole block of statements is optional; I would bet *only if* there is only one block of statements in the trigger (i.e.: no WHEN blocks along with the FOR EACH ROW block) ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.