Subject | Problem with SQL syntax |
---|---|
Author | slsolutions2002 |
Post date | 2002-02-15T16:41:33Z |
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
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