Syntax Errors in Triggers
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.