create or replace trigger YOUR_TRIGGER before update on AAAA
for each row
when (new.year=old.year and new.status = 1)
begin
-- your code here
end;

Now, i'm sending the correct sample! without the column on before update clause!

Try, this! reply to me the result!

---------------------------------------
Silas - [email protected]