triggers

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 ..

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

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

so ...

Code:

---

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

---

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

Thanks for the info.