Subject | ...create trigger problem |
---|---|
Author | Markus Franz |
Post date | 2004-06-24T10:32:09Z |
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
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