RE: [firebird-tools] Re: Database Workbench: SET TERM
Author
Alan McDonald
Post date
2007-12-06T23:18:20Z
> --- 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