Subject | Corrigenda to TECHNICAL INFORMATION SHEET: Maintaining an Auditable Series |
---|---|
Author | Raymond Kennington |
Post date | 2004-11-05T23:14:57Z |
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.
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.