Larry,
I'm only using AFTERs so I cannot comment on the BEFOREs. I can assure you that an UPDATE to SYS_NEW in an AFTER trigger does not invoke a new instance of the trigger.
> I can't give you an exact version but it is somewhere in the 7.0 > releases. I've been doing an UPDATE ... WHERE CURRENT OF SYS_NEW for some > time.
Cool. And I thought I read all of the update memos! A few questions:
Is this only in AFTERs, or does it work in BEFOREs also?
Are you guaranteed not to invoke a call to the trigger you're UPDATEing from?
Do you have to worry about cross-trigger calls? That is, if you UPDATE in the AFTER INSERT trigger, do the BEFORE and AFTER UPDATE triggers get called? -- Larry
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
