Trigger Previous topic Chapter index Next topic

MUSIKFORMAT_RV

 

Beschreibung

Trigger für das RecordVersion Feld

 

Definition

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

 

     Previous topic Chapter index Next topic