- 论坛徽章:
- 1
|
create trigger "hakcxtab".tu_estiloss update on "hakcxtab".estiloss
referencing old as old new as new
for each row
when ((((((old.caseno != new.caseno ) OR (old.bzh !=
new.bzh ) ) OR (old.zhx != new.zhx ) ) OR (old.mxxzh != new.mxxzh
) ) OR (old.fgs != new.fgs ) ) )
(
execute procedure "hakcxtab".p_estiloss(old.caseno ,
old.bzh ,old.zhx ,old.mxxzh ,old.fgs ,'3' )),
when (1 )
(
update "hakcxtab".regcase set "hakcxtab".regcase.timestamp
= CURRENT year to fraction(3) where ((fgs = old.fgs ) AND (caseno =
old.caseno ) ) ,
execute procedure "hakcxtab".p_estiloss(new.caseno ,
new.bzh ,new.zhx ,new.mxxzh ,new.fgs ,'2' )); |
|