Hi, I would like to know if it is possible to fire a trigger in Firebird (After Insert or Update or Delete) that keeps track of inserts, updates or deletes from a given table and then take those changes and propagate them to another database.

For Example (MSSQL)
After deleting a row from [dbo.table1] the same row from TestDB2.table1 is deleted also

CREATE TRIGGER [TR2] ON TestDB1.table1
FOR DELETE
AS

DELETE FROM TestDB2.dbo.table1
WHERE field1 = (SELECT field1 FROM DELETED)

My question is... I can do the same on a FireBird DataBase?

Thank you,

Kostas

you can do more :P

you can make before or after I U D

CREATE TRIGGER