At 11:16 AM 18/04/2007, you wrote:

>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!

Remove the semicolon following the END statement.

./heLen