triggers

[prodadmin]

Hi ,

Can any one pls explain me what is this :new and :old means.or what exactly we are reffereing to.


BEGIN
if (:new.ASR = 'A' and :old.ASR != 'A') then

EX_TRIGGERS.Ex_Insert( 'xcr'
, :new.Company_ID
, 'ON'
, 'Jobs with zero"
);

Thank you ..

[slimdave]

:new.ASR is the value of ASR after the update operation.

: old.ASR is the value of ASR before the update operation.

so ...
if (:new.ASR = 'A' and ld.ASR != 'A') then


is testing to see if the value of ASR changed to 'A'.

[prodadmin]

Thanks for the info.