eh aquí el script
sql
CREATE TRIGGER OBI_PEDIME FOR SAAIO_PEDIME ACTIVE AFTER INSERT OR UPDATE OR DELETE POSITION 0 AS DECLARE iID INTEGER; DECLARE sTIPO VARCHAR(1); DECLARE sREFE VARCHAR(15); BEGIN IF (INSERTING) THEN BEGIN sTIPO = 'I'; sREFE = NEW.NUM_REFE; END ELSE IF (UPDATING) THEN BEGIN sTIPO = 'U'; sREFE = OLD.NUM_REFE; END ELSE IF (DELETING) THEN BEGIN sTIPO = 'D'; sREFE = OLD.NUM_REFE; END IF (SELECT COUNT(SYS_ID) FROM SYS_LOG WHERE (SYS_TABLA='SAAIO_PEDIME') AND (SYS_REFE=:sREFE))=0 THEN INSERT INTO SYS_LOG (SYS_TIPO,SYS_FECHA,SYS_OPER,SYS_TABLA,SYS_REFE,SYS_CAMPO,SYS_VALOR,SYS_NUMCVE) VALUES (:sTIPO,'NOW','O','SAAIO_PEDIME',:sREFE,'NUM_REFE',:sREFE,1); END;
Saludos...