Subject Re: Database Workbench: SET TERM
Author Steve Miller
--- In firebird-tools@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>
> > I'm running a long script, concatenated from many other
> > 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
>
> This is interesting...
> 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 ;


Yes, exactly. IBExpert seems to do fine with it.


> 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.


The prior statements are all comments. I little unusual, I know, but
if you knew our generation process, you would understand.

Steve Miller