Atau lebih gampang dibikin Trigger nya per kolom saja.
Jadi seperti ini :
CREATE TRIGGER t_colA AFTER UPDATE OF "ColA"
ORDER 1 ON "NAMA_TABLE_SOURCE"
REFERENCING NEW AS new_ref FOR EACH ROW
BEGIN
INSERT INTO "NAMA_TABLE_TARGET" (Colom,Value) VALUES
('ColA',new_ref.ColA);
END
CREATE TRIGGER t_colB AFTER UPDATE OF "ColB"
ORDER 1 ON "NAMA_TABLE_SOURCE"
REFERENCING NEW AS new_ref FOR EACH ROW
BEGIN
INSERT INTO "NAMA_TABLE_TARGET" (Colom,Value) VALUES
('ColB',new_ref.ColB);
END
dan seterusnya
Tapi jadi ndak praktis kalau kolomnya banyak sih :P
-----------------------------------------------
INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
