Re: Triggers?

Joseph Kormann wrote: > >Howdy. At work we're starting to play / test triggers on our SE4.13UC1 >(HPUX). Is there any way that you can recommend that's pretty >straightforward to reduce / eliminate trigger-cascade? Basically I'm >fearing an endless loop of triggers if we're not careful. > > Thanks, > Joseph Joseph, You must be a propaganda shill for Informix. ;-)) There is a restriction on triggers that absolutely prevents the recursion that would cause an endless loop. You cannot reference the triggering column in the the trigger code or any stored procedure it invokes. The reason for this restriction is exactly to prevent recursion. Most of us out here wish this restriction would go away. This is a popular feature reqest, judging by the postings I have seen. -- -- Jake (Never ate a well-mannered goose - a propaganda) . . _..-'( )`-.._ ./'. '||\\\\. }\\_/{ .//||` .`\\. ./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\. ./'..|'.|| |||||\\`````` \\'@'/ ''''''/||||| ||.`|..`\\. ./'.||'.|||| ||||||||||||. | .|||||||||||| ||||.`||.`\\. /'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\ '.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.` '.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.` |/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\| V V V }' `\\ /' `{ V V V \\ \\ \\ V / / / +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+