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

EXPORTACTITEMS_SETTESTWEIGHT

Описание

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

Определение

CREATE TRIGGER EXPORTACTITEMS_SETTESTWEIGHT FOR EXPORTACTITEMS
ACTIVE BEFORE INSERT OR UPDATE POSITION 100
AS
begin
  if (new.OPERATIONID in (5,13,17,64,65,70)) then
    new.TESTWEIGHT = new.WEIGHT;
  if (new.OPERATIONID in (22)) then
    new.TESTWEIGHT = 0;
end