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

SILAGE_UpdateSilageGroupWeight

Описание

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

Определение

CREATE TRIGGER "SILAGE_UpdateSilageGroupWeight" FOR SILAGE
ACTIVE AFTER UPDATE POSITION 1
as
begin
--exception oops;
  if ((old.Weight is null) and not (new.WEIGHT is null))
  then
    update SILAGE set silage.Weight = 0
    where silage.SilagePackID = new.SilagePackID
      and silage.Weight is null
      and silage.SilageID <> new.SilageId;
end