Hello,

I have table Invoice (which is header table) and InvoiceItem (which is items table) and InvoiceID as foreign key in secound table which is reference first table.
Now, I have some fields which is sum or products of some another columns in InvoiceItems which is depend of business logic.
So, I was create a trigger and procedure for InvoisItem table:

CREATE OR ALTER TRIGGER INVOICEITEMS_A0 FOR INVOICEITEMS
ACTIVE AFTER INSERT OR UPDATE POSITION 0
AS
BEGIN
EXECUTE PROCEDURE SP_ADM_SUMFIELDS('INVOICEITEMS', NEW.INVOICEID);
END

CREATE OR ALTER PROCEDURE SP_ADM_SUMFIELDS (TABLENAME VARCHAR(30), ID INTEGER)
AS
BEGIN
UPDATE INVOICEITEMS SET SUMCOLUMN = COLUMN1 + COLUMN2 WHERE INVOICEID = :ID;
SUSPEND;
END

Where is a Firebird Leak error???

Thanks in advance...