Hi all,
I want to record all changes in tables (insert/update/delete).
I can do this by creating triggers for each tables, triggers ex :
SET TERM ^ ;
CREATE TRIGGER UPD_M_AREA FOR M_AREA ACTIVE
AFTER UPDATE POSITION 10
AS
BEGIN
insert into log (id_tbl,tbl_nm, opr)
values(new.ID, 'M_AREA', 'U');
END^
SET TERM ; ^
SET TERM ^ ;
CREATE TRIGGER DEL_M_AREA FOR M_AREA ACTIVE
AFTER DELETE POSITION 10
AS
BEGIN
insert into log (id_tbl, tbl_nm, opr, sql_del)
values(old.ID, 'M_AREA', 'D', old.dscp);
END^
SET TERM ; ^
SET TERM ^ ;
CREATE TRIGGER INS_M_AREA FOR M_AREA ACTIVE
AFTER INSERT POSITION 10
AS
BEGIN
insert into log (id_tbl,tbl_nm, opr)
values(new.ID, 'M_AREA', 'I');
END^
SET TERM ; ^
Or, I can record changes via my app, which one do you thing is better,
regarding database performance and size?
Thanks in advance and best regards,
sugiarto
