CREATE OR REPLACE TRIGGER "ITS"."LANECONFIGYANWUU" AFTER
UPDATE OF "GLIGHTTIME", "PDCD", "PERIODTIME", "PHASEINFO"
ON "ITS"."LANECONFIG"
FOR EACH ROW
declare
num number;
begin
select count(*) into num from wang_road
where (w_crossid=:new.CrossingID)
and (lanename=:new.LaneName);
if num>0 then
update wang_road
set pdcd=:new.pdcd ,
periodtime=:new.periodtime ,
glighttime=:new.glighttime,
PhaseInfo=:new.PhaseInfo
where (w_crossid=:new.CrossingID)
and (lanename=:new.LaneName);
end if ;
end
;
UPDATE OF "GLIGHTTIME", "PDCD", "PERIODTIME", "PHASEINFO"
ON "ITS"."LANECONFIG"
FOR EACH ROW
declare
num number;
begin
select count(*) into num from wang_road
where (w_crossid=:new.CrossingID)
and (lanename=:new.LaneName);
if num>0 then
update wang_road
set pdcd=:new.pdcd ,
periodtime=:new.periodtime ,
glighttime=:new.glighttime,
PhaseInfo=:new.PhaseInfo
where (w_crossid=:new.CrossingID)
and (lanename=:new.LaneName);
end if ;
end
;
OF "GLIGHTTIME", "PDCD", "PERIODTIME", "PHASEINFO"
去掉试试