"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