Subject | Re: [ib-support] XCase and Interbase 6 |
---|---|
Author | Nando Dessena |
Post date | 2001-02-07T18:30:32Z |
Carlo,
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
> Dynamic SQL ErrorYou need to use SET TERM to run this kind of script under isql, because
> SQL error code = -104
> Unexpected end of command
> Statement: CREATE TRIGGER T_BI_MyTable FOR MyTable BEFORE INSERT AS
> DECLARE VARIABLE row_count INTEGER
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