Subject Re: i want to update datas of parametric tablename in trigger
Author lacakus
>
> CREATE OR ALTER TRIGGER CUST_BU0 FOR CUST
> ACTIVE BEFORE UPDATE POSITION 0
> AS
> ....
> begin
> .....
>
what about using dynamic dml ?:

execute statement 'update account' || cast(new.type as varchar(3)) || ' set balance=balance+new.total;';

-Laco.