CREATE TRIGGER PROJECTCOMPANY_ACTIONS FOR T_PROJECT_COMPACTION 114 POSITION 0 as
 declare variable var1 integer;
 declare variable var2 integer;
 declare variable var3 integer;
 declare variable var4 timestamp;
 declare variable var5 integer;
 declare variable var6 integer;
 declare variable var7 integer;
 declare variable var8 timestamp;
 declare variable var9 integer;
begin
  if (inserting or updating) then var1=new.n_project_company;
  if (deleting) then var1=old.n_project_company;
/*LAST PLAN DATE*/
  select first 1 A.n_project_compaction from t_project_compaction A
  where A.n_project_company=:var1 and A.date_plan=
  (select max(B.date_plan) from t_project_compaction B
  where B.n_project_company=:var1 and B.date_plan is not null) into var2;
/*LAST FACT DATE*/
  select first 1 A.n_project_compaction from t_project_compaction A
  where A.n_project_company=:var1 and A.date_fact=
  (select max(B.date_fact) from t_project_compaction B
  where B.n_project_company=:var1 and B.date_fact is not null) into var3;
/*FIRST FACT DATE AND USER*/
  select min(date_fact) from t_project_compaction where n_project_company=:var1 and date_fact is not null into var4;
  select first 1 n_user2 from t_project_compaction where n_project_company=:var1 and date_fact is not null and date_fact=:var4 into var5;
/**/
  update t_project_company set n_project_compaction1=:var2, n_project_compaction2=:var3, firstact_date=:var4, firstact_user=:var5 where n_project_company=:var1;
/*PROJECT LASTDATEFACTS*/
/*changed for simple last operation date*/
/*if (inserting or updating) then var6=new.n_project;*/
/*if (deleting) then var6=old.n_project;*/
/*if (inserting or updating) then var7=new.n_user2;*/
/*if (deleting) then var7=old.n_user2;*/
/*select max(date_fact) from t_project_compaction where n_project=:var6 and date_fact is not null and n_user2=:var7 into var8;*/
/*delete from t_project_lastdatefacts where n_project=:var6 and n_user=:var7;*/
/*if (:var8 is not null) then insert into t_project_lastdatefacts(n_project,n_user,lasdatefact) values (:var6,:var7,:var8);*/
if (inserting or updating) then var6=new.n_project;
if (deleting) then var6=old.n_project;
if (inserting or updating) then var7=new.n_user1;
if (inserting or updating) then var9=new.n_user2;
if (deleting) then var7=old.n_user1;
if (deleting) then var9=old.n_user2;
delete from t_project_lastdatefacts where n_project=:var6 and n_user=:var7;
delete from t_project_lastdatefacts where n_project=:var6 and n_user=:var9;
if (var7=var9) then var9=0;
if (var7>0) then insert into t_project_lastdatefacts(n_project,n_user,lasdatefact) values (:var6,:var7,'now');
if (var9>0) then insert into t_project_lastdatefacts(n_project,n_user,lasdatefact) values (:var6,:var9,'now');
end