триггер

CREATE TRIGGER table_BI0 FOR table
ACTIVE BEFORE INSERT POSITION 0
as
begin



   new.ID = gen_id(T_ID, 1);
   NEW.MOD_TIME = 'now';
   if (exists(select ID from TABLE where ID = new.ID)) then
     begin
       update TABLE set
        NAME = new.NAME,
        QUANTITY = new.QUANTITY
       where ID = new.ID;
     end
  else
     begin
       insert into TABLE (
        ID,
        NAME
        QUANTITY)
       values (
        new.ID,
        new.NAME
        new.QUANTITY);
     end
     
end

NEW.MOD_TIME = 'now';