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

GRADEBASIS_SetState

Описание

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

Определение

CREATE TRIGGER "GRADEBASIS_SetState" FOR GRADEBASIS
ACTIVE BEFORE INSERT OR UPDATE POSITION 10
AS
begin
  if (new.state = 1) then
    update gradebasis set state = 0
    where gradebasis.gradebasisid <> new.gradebasisid
      and gradebasis.storageid = new.storageid
      and gradebasis.state = 1;
end