Syntax Errors in Triggers
From InterBase
Go Up to InterBase Procedure and Trigger Language
InterBase may generate errors during parsing if there is incorrect syntax in the CREATE TRIGGER
statement. Error messages look similar to this:
Statement failed, SQLCODE = -104 Dynamic SQL Error -SQL error code = -104 -Token unknown - line 4, char 9 -tmp
The line numbers are counted from the beginning of the CREATE TRIGGER
statement, not from the beginning of the data definition file. Characters are counted from the left, and the unknown token indicated will either be the source of the error or immediately to the right of the source of the error. When in doubt, examine the entire line to determine the source of the syntax error.