Subject | Re: Database Workbench: SET TERM |
---|---|
Author | Steve Miller |
Post date | 2007-12-06T23:14:36Z |
--- In firebird-tools@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
if you knew our generation process, you would understand.
Steve Miller
>Yes, exactly. IBExpert seems to do fine with it.
> > 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 ;
> But more interesting, the error message is referring to line 257. Iwould be
> looking at the prior statement(s) for a clue as to why this validstatement
> 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