Hi All,

I have just created a Trigger:

CREATE TRIGGER Tri_Area FOR AREA
BEFORE INSERT
AS
BEGIN
new.SEQ = GEN_ID(AREA_NEXTNO,1);
END;

When I try to create this trigger through Flame Robin I get the Error:

Preparing query: CREATE TRIGGER Tri_Area FOR AREA
BEFORE INSERT
AS
BEGIN
new.SEQ = GEN_ID(AREA_NEXTNO,1)

*** IBPP::SQLException ***
Context: Statement::Prepare( CREATE TRIGGER Tri_Area FOR AREA
BEFORE INSERT
AS
BEGIN
new.SEQ = GEN_ID(AREA_NEXTNO,1) )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 5, column 35


Execute time: 00:00:00.

Can Anyone explain this error please!

Thank you