Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Question Unanswered: Help needed on FireBird Triggers

    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

  2. #2
    Join Date
    Mar 2009
    Posts
    24
    you can do more :P

    you can make before or after I U D

    CREATE TRIGGER

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •