At 09:44 AM 6/11/2004 +1030, Raymond Kennington wrote:

>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.

Thanks Raymond! Now fixed.

Helen