> 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