triggers

**prodadmin** · 07-08-2003, 10:11 AM

Hi ,

Can any one pls explain me what is this :new and

ld means.or what exactly we are reffereing to.

BEGIN
if (:new.ASR = 'A' and

ld.ASR != 'A') then

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

Thank you ..

**slimdave** · 07-08-2003, 10:35 AM

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

**prodadmin** · 07-09-2003, 08:44 AM

Thanks for the info.

Thread: triggers