title: Trigger SQL Server for Firebird
body: <p>I have a SQL Server trigger that I have tried to convert for Firebird but seems like I have some trouble with it.</p>
  <p>Here is my SQL trigger:</p>
  <pre><code>CREATE TRIGGER [dbo].[IDSOFT_INTERV_UI]
     ON [MMAINT_SOCO_PROD].[dbo].[T_ZONES_LIBRES_UI]
     AFTER UPDATE
  AS 
  BEGIN
      IF UPDATE(STR_ZONE_LIBRE)
          BEGIN
  
          DECLARE @ui_id int,
                  @num_interv int;
                  
          SELECT @ui_id = d.LIEN_UI,
                 @num_interv = e.NUM_INTERV
          FROM T_LIGNE_BT a
          inner join T_BT b on b.NUM_BT = a.CLE_BT
          inner join T_UI c on c.NUM_UI = b.CLE_UI
          inner join T_ZONES_LIBRES_UI d on d.LIEN_UI = c.NUM_UI
          inner join T_INTERV e on e.NOM_INTERV = d.STR_ZONE_LIBRE
          WHERE d.LIEN_UI in (select LIEN_UI from INSERTED) and d.INDICE_ZONE_LIBRE = 20;     
          
      Update a
      set a.cle_element = e.NUM_INTERV
      from t_ligne_bt a
      inner join T_BT b on b.NUM_BT = a.CLE_BT
      inner join T_UI c on NUM_UI = b.CLE_UI
      inner join T_ZONES_LIBRES_UI d on d.LIEN_UI = c.NUM_UI
      inner join T_INTERV e on e.NOM_INTERV = d.STR_ZONE_LIBRE
      where d.LIEN_UI = @ui_id
          and b.cle_ip is not null 
          and b.cle_ip &lt;&gt; 100000
          and a.type_ligne_bt like 'I'
  
        END
  END
  </code></pre>
  <p>I'm really having problems to replicate the same for Firebird.</p>
  <p>Can anyone help me please.</p>