"localhost:/firebird/data/ILICHEVSK2.FDB". Триггеры

SILAGE_SETINVENTORYID

Описание

(Нет описания для триггера SILAGE_SETINVENTORYID)

Определение

CREATE TRIGGER SILAGE_SETINVENTORYID FOR SILAGE
ACTIVE BEFORE UPDATE POSITION 0
AS
declare AInventoryID Integer;
begin
  if (((new.weight is null and old.weight is not null)
       or (new.weight is not null and old.weight is null)
       or (new.weight <> old.weight)
      )
      and current_user = 'SYSDBA'
     )
  then begin
--    AInventoryID = gen_id(inventoryidgen, 1);
--    update silage set inventoryid = AInventoryID where ;
--    insert into silage
    -- дописать
  end
end