Subject | RE: [firebird-tools] Database Workbench: SET TERM |
---|---|
Author | Alan McDonald |
Post date | 2007-12-06T22:52:29Z |
> I'm running a long script, concatenated from many otherThis is interesting...
> scripts. It starts with a number of comments marked with /*
> and */. Then the first line of code is:
>
> SET TERM !!;
>
> Database Workbench gives a Script Error on this:
>
> ============================
> Script Error:
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 257, column 5
> TERM
> ============================
>
> Is there any way to tell Database Workbench to ignore the SET
> TERM command?
>
> Steve Miller
Firstly, the scripts you are generating are obvisouly using !! as a
terminator, if you remove this statement from the script, the statements
relying on !! Terminator will fail since the default is probably ;
But more interesting, the error message is referring to line 257. I would be
looking at the prior statement(s) for a clue as to why this valid statement
is raigin an error.
Alan