Re: Triggers

On 11/23/2005 3:44 AM, Achilleus Mantzios wrote:

> O Neil Saunders έγραψε στις Nov 22, 2005 :
> 
>> And change AFER INSERT to BEFORE INSERT
> 
> 1) it doesnt make any difference since we are updating 
> a different table than the trigger's one

In this particular case it doesn't. In general, another BEFORE trigger 
can still modify the new row, so your trigger might not see the final 
values in NEW.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #