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

SET_DATALOCKID

Описание

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

Определение

CREATE TRIGGER SET_DATALOCKID FOR DATALOCKS
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.DATALOCKID IS NULL) THEN
    NEW.DATALOCKID = GEN_ID(GEN_DATALOCKS_ID,1);
  NEW.createtime = current_timestamp;
  execute procedure users_getid ('') RETURNING_VALUES NEW.CreateUserID;
  If (new.DataLockLevel is null) then
    new.DataLockLevel = 255;
END