hi, what happens when a (for example) a update trigger on table t1 fires a further update trigger on t1 and so on. could that cause an endless loop? and if so, how can the chain be broken?
i rember reading something about this particular subject once. and i think that there was a specific statement within the trigger which can determine if the trigger was in affect (indirectly) fired from another. i'm not sure but, i think elke had answered this one. thanx in advance, john [EMAIL PROTECTED] [EMAIL PROTECTED]