Subject Re: [ib-support] XCase and Interbase 6
Author Nando Dessena
Carlo,

> Dynamic SQL Error
> SQL error code = -104
> Unexpected end of command
> Statement: CREATE TRIGGER T_BI_MyTable FOR MyTable BEFORE INSERT AS
> DECLARE VARIABLE row_count INTEGER

You need to use SET TERM to run this kind of script under isql, because
the default terminator is ; (which is used in the body of a trigger
too).

Addign SET TERM ^; before the CREATE TRIGGER statement and SET TERM ;^
just after does the trick for isql.
Don't know if there's a way to tell XCase to add them automatically.
Regarding the fact that the script works under XCase, it is probably
executed one statement at a time and not as a whole.
--
____
_/\/ando