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

IT_CheckPeriod

Описание

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

Определение

CREATE TRIGGER "IT_CheckPeriod" FOR IT
ACTIVE BEFORE INSERT OR UPDATE OR DELETE POSITION 0
AS
declare variable CLOSINGDATE DATE;
begin
  for
    select closingdate from periods where state = 1
    into :closingdate
  do closingdate = :closingdate;
  if (new.regdate <= :closingdate or old.regdate <= :closingdate) then exception notaccessperiod;
END