RE: [firebird-support] A error of too many concurrent execution of the same request on a trigger - Email found in subject

[Leyne, Sean]

> The trigger is like this:

What is the TRIGGER declaration, what table?  BEFORE or AFTER??



>   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 fin_acc_cash_diary
>              where f_acd_id < :nid
>              order by f_acd_id desc
>              into :ye;

"Ye" is not declared as a variable.

If you are trying to refer to the "Ye" column, only "old.ye" and "new.ye" 
context variables are available.


Sean