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?

Thank you, a lot, guys!

Antonio Carlos
antoniocarlos (at) cys.com.br