Thank you Helen you have solved my problem.
I now use TIBSQL with check parameters turned off,
and it works.
Amazingly touchy stuff.

Thanks again.

Regards,

RObert.

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 11:53 PM 3/11/2003 +0000, you wrote:
> >The following code works fine in IBConsole (6.0.1.6)
> >But falls over in IBQuery saying
> >
> >Token unknown - line 1, char 4
> >TERM
> >
> >I have no Ideas. Can anyone help?
> >BTW without Set Term not even IBConsole works.
>
> 1. SET TERM isn't a DSQL command - it's ISQL and will only work in
ISQL or
> in a script.
> 2. You can't run multiple statements in a query. They must be run
in a
> script.
> 3. If you want to create a procedure module (trigger, SP)
interactively,
> use IB_SQL, the DSQL window, click the Params checkbox off, and you
won't
> need SET TERM. (Don't put a terminator on the last END statement
though).
>
> IB_SQL also has a very handy script tool that uses TIB_Script.
>
> Helen