Subject Problem with SQL syntax
Author slsolutions2002
Hello:

Can someone tell me what is wrong with this statement:
SET TERM !! ;
CREATE TRIGGER tgPOSTCOSTDETAIL FOR COSTCATEGORYDETAIL
AFTER UPDATE
POSITION 1
AS
BEGIN
SELECT * FROM COSTCATEGORYDEFINITIONS
WHERE COSTCATEGORYNO = NEW.COSTCATEGORYNO;
END !!
SET TERM ; !!
COMMIT;

I get error message:
ISC ERROR CODE: 335544569
ICI ERROR MESSAGE
DYNAMIC SQL ERROR = -104
TOKEN UNKNOWN - LINE 7, CHAR 44
;

I believe I am following the syntax right out of the book but
whatever SQL statement I put between BEGIN and END !! I get an error
If I leave off the trailing semi-colon it get a different error.

Thanks