Subject ...create trigger problem
Author Markus Franz
Hi firebird group,

when i try to execute my sql file (definition of the file is below) i get
this error:

h-2.05b$ ./isql -u user -p pwd localhost:/var/firebird/test.fdb -i
/Firebird_Trigger.sql
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 9, char 55
-;
Expected end of statement, encountered EOF



Here is the Definiton of the Firebird_Trigger.sql file:

SET TERM !! ;
CREATE TRIGGER AUSLAGE_CHANGE FOR AUSLAGE
ACTIVE
AFTER DELETE OR UPDATE
POSITION 0
AS
BEGIN
SELECT * FROM WEITERVERARB WHERE AUSLAGE = OLD.NUMMER ;
IF (sqlcode = 0) THEN
exception auslage_nummer;
END !!
SET TERM ; !!

Could anyone tell me what's wrong with the statement?
Thank for your help and feedback.
Regards, markus