Hi,

I try to update a column value in a trigger after updating a row, but it raises
a error of too many concurrent execution of the same request.
I know this is caused by recursion, but I can't avoid it.
I want update a column value of all the rows which is after the updating rows.

ID ---------- Num1 ---------- Num2 --------- YE
1 ---------- 15 ---------- 25 ---------- 28
2 .......
3 .......-----------------------------------32
4 ------------20 ----------- 35 -----------27 ---> 32+20-35 =27
5
6
7

if in row 4, then num1 or num2 is changed, then for the rows 4 to 7,
the columns YE will be changed followed.

---------------------------------------------------------------------

The trigger is like this:


declare variable nID integer;
declare variable maxid integer;


if (updating or (deleting) ) then
begin
select max(f_acd_id) from table1 into :maxID;
nid = old.f_acd_id;

while (nid < :maxid) do
begin
select first 1 balance from table1 where f_acd_id < :nid
order by f_acd_id desc
into :ye;

update table1
set balance = :ye + new.num1 - new.num2
where f_acd_id = :nid;
nid = :nid + 1;
end
end

Looking forward to your help, thanks.