Antonio,

> Hi there!
>
> // ------------ Scenario:
>
> Delphi 7
> FirebirdSQL 1.5.4
> IBObjects 4.8.6
> IB_SQL 4.7.Beta 15 (for testing purposes)
>
> // ------------ In a trigger like this:
>
> SET TERM !! ;
> CREATE OR ALTER TRIGGER SET_GEN_L_CRITICA FOR MYTABLE
> BEFORE INSERT AS BEGIN
> DELETE FROM MYTABLE2;
> END!!
> SET TERM ; !!
>
> // ------------ I got the following message:
>
> Token Unknown - line 4, char 4
>
> // ------------ Adding a space between END and !! it works:
>
> ...
>
> END !!
> SET TERM ; !!
>
> // ---------------------------------------------------------
>
> Am I missing something?

The way you declared your terminator put a space after it:

SET TERM !! ;


For it to do what you want or expect you should do this:

> SET TERM !!;

The question here is do you think I should trim the whitespace.
I don't think this was intentional and trimming the whitespace would
probably be a good idea.

What do others think?

PS. I'm going to be spotty for a bit while I get relocated.

Regards,
Jason Wharton