Re: HELP with triggers and updates;

Patrick McCarthy wrote:

> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> create trigger status_action
> after
> update of status
> on test
> begin
> >>>>>>I need somekind of statement here to change it
> >>>>>>ie set status = 'PENDING' where status = 'FIRED'
> end;
> /
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>

You want to make it a before update trigger something like this:

create trigger status_action
after update of status on test
when (:new.status = 'FIRED')
for each row
begin

    :new.status = 'PENDING';
end; Received on Wed Dec 13 1995 - 00:00:00 CET