--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

>
> At 12:02 PM 25/01/2006, you wrote:
> >w/IBODatabase, IBQuery and FB 1.0.0.794
> >
> >When I execute the complete script below in IB_SQL
> >(as a new db with the required GENERATOR), it returns
> >without error.
> >
> >When I run it through IBOQuery flattened out as a single
> >string, it returns "Token Unknown" on the first COMMIT.

snip

> >
> >I presume that there are some clues to running DSQL
> >through an IBQuery (or other similar components)
> >that I need to become aware of.
>
> Erm, yes. A statement object such as TIBOQuery is for a single
> statement. If you want to run a script, use a TIB_Script component!

I'll match your "Erm" with my "Ahh."

The IB_Script worked like magic.

Is it the concluding <;> semicolon which defines the
"single statement?

And as such, then, <COMMIT;> also equals a "single statement?"

Is a "statement object" then, anything which descends from
IB_Statement?

Barry