Trigger

BLOCKVOR_SCHICHTVOR_RV

Beschreibung

Trigger für das RecordVersion Feld

Definition

CREATE TRIGGER BLOCKVOR_SCHICHTVOR_RV FOR BLOCKVORLAGEN_SCHICHTVORLAGEN
ACTIVE BEFORE UPDATE POSITION 0
AS
BEGIN
  IF (OLD.BSRECORDVERSION < 2147483637) THEN
    NEW.BSRECORDVERSION = OLD.BSRECORDVERSION + 1;
  ELSE
    NEW.BSRECORDVERSION = 1;
END