Larry,
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.
> You have to be careful about using triggers to alter the table on which the
> trigger is based. We do this, but only to update the row that triggered
> the action in the first place by using "where current of ..." This will
> not cause the trigger to fire again.
I recall trying something like this some time ago and finding that the SYS_NEW and SYS_OLD cursors did _not_ allow updating. Am I mistaken, or is this something that changed in an in-line release of the product?
-- 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]
