my sqlerror 1442saranya jothiprakasam November 23, 2011 at 5:18 PM
i got the error as can't update table dctblloaddata in stored function/trigger because it is already used by statement which invoked this stored fuction/trigger when trying to insert the row.. my trigger is as follows
delimiter $$
create trigger s
after insert on dctblloaddata
for each row begin
declare v_value long;
select LoadProfileID from cfw.dctblloaddata order by LoadProfileID desc limit 1 into v_value;
update `dctblloaddata` set AvgCurrent=-99999.99, AvgVolt=-99999.99, ActiveDemandFwd=-99999.99, ApperentDemandFwd=-99999.99
where
((LoadProfileID=v_value ) AND (AvgCurrent>800 OR
AvgCurrent = 0 OR
AvgCurrent =-99999.99 OR
AvgVolt >300 OR
AvgVolt=0 OR
AvgVolt=-99999.99 OR
ActiveDemandFwd=0 OR
ActiveDemandFwd=-99999.99 OR
ApperentDemandFwd=0 OR
ApperentDemandFwd=-99999.99)) ;
end $$
delimiter ;
give me some suggestion for me why it is not properly working.
my sqlerror 1442saranya jothiprakasam November 23, 2011 at 5:18 PM
i got the error as can't update table dctblloaddata in stored function/trigger because it is already used by statement which invoked this stored fuction/trigger when trying to insert the row.. my trigger is as follows delimiter $$ create trigger s after insert on dctblloaddata for each row begin declare v_value long; select LoadProfileID from cfw.dctblloaddata order by LoadProfileID desc limit 1 into v_value; update `dctblloaddata` set AvgCurrent=-99999.99, AvgVolt=-99999.99, ActiveDemandFwd=-99999.99, ApperentDemandFwd=-99999.99 where ((LoadProfileID=v_value ) AND (AvgCurrent>800 OR AvgCurrent = 0 OR AvgCurrent =-99999.99 OR AvgVolt >300 OR AvgVolt=0 OR AvgVolt=-99999.99 OR ActiveDemandFwd=0 OR ActiveDemandFwd=-99999.99 OR ApperentDemandFwd=0 OR ApperentDemandFwd=-99999.99)) ; end $$ delimiter ; give me some suggestion for me why it is not properly working.
Post your Comment