Fórum Trigger Insert - De uma tabela para muitas #457433

CREATE trigger teste_bi for country /*O pós fixo bi significa: Before Insert*/
active before insert position 0
AS
begin
  /* Insert na tabela desejada, coloquei os valores fixos apenas como exemplo*/
  insert into TABELAX (CODIGO, NOME)
        values (1, 'EMANOEL DEIVISON');
end

CREATE trigger teste_bi for country /*O pós fixo bi significa: Before Insert*/
active before insert position 0
AS
begin
  /* Insert na tabela desejada, coloquei o nome dos campos apenas como exemplo*/
  insert into TABELAX 
        values (1, tabelaX.nome, tabelaY.valor, tabelaZ.data);
end

SET TERM ^;
CREATE TRIGGER BI_ATABLE FOR ATABLE
ACTIVE BEFORE INSERT POSITION 1
AS
BEGIN
IF (NEW.CAPTURE_DATE IS NOT NULL) THEN
BEGIN
NEW.CAPTURE_TIME =
CAST(EXTRACT (HOUR FROM NEW.CAPTURE_DATE) AS CHAR(2))|| ':' ||
CAST(EXTRACT (MINUTE FROM NEW.CAPTURE_DATE) AS CHAR(2))|| ':' ||
CAST(EXTRACT (SECOND FROM NEW.CAPTURE_DATE) AS CHAR(7));
END
END ^
SET TERM ;^

SET TERM ^;
RECREATE TRIGGER BI_ATABLE FOR ATABLE
ACTIVE BEFORE INSERT POSITION 1
AS
BEGIN
/* do nothing */
END ^
SET TERM ;^
COMMIT;

SET TERM ^;
RECREATE TRIGGER BI_ATABLE FOR ATABLE
ACTIVE BEFORE INSERT POSITION 1
AS
BEGIN
IF (NEW.CAPTURE_DATE IS NOT NULL) THEN
BEGIN
NEW.CAPTURE_TIME = CAST(NEW.CAPTURE.DATE AS TIME);
END
END ^
SET TERM ;^
COMMIT;

Insert into tabela (campo_1,campo_n)
Select tabela1.campo_a, tabela2.campo_b from tabela1, tabela2;