Subject Corrigenda to TECHNICAL INFORMATION SHEET: Maintaining an Auditable Series
Author Raymond Kennington
The trigger level 8 in the following trigger was incorrectly entered in
the document as 9. This value is correct in the script.

CREATE TRIGGER BI_INSERT_INV_HDR
FOR INV_HEADER
ACTIVE BEFORE INSERT POSITION 8 AS
BEGIN
IF (NEW.INV_ID IS NULL) THEN
NEW.INV_ID = GEN_ID(GEN_INV_HEADER_ID, 1);
IF (NEW.INV_DATE IS NULL) THEN
NEW.INV_DATE='NOW';
NEW.INV_OPERATOR = USER;
END

In
CREATE TRIGGER BI_INSERT_INV_NUM
FOR INV_HEADER

the line
IF INV_NO > 0 THEN

should have parentheses.

Raymond.