[ronson]

he puesto esto:

AS
DECLARE VARIABLE TOTAL DOUBLE PRECISION;
BEGIN
FOR
SELECT SUM(SUBTOTAL) FROM LINEAALBARANES
WHERE ANNO=NEW.ANNO AND NUM_ALB=NEW.num_alb
INTO :TOTAL
DO
END

y me da error en el END, falta algun ;?