I don't know, but consider that, compared with IBX, IBO IB_Query is
another planet. It's a sophisticated compoent higly tailored for data
retrival (select...).
For that kind of statement, the IB_DSQL is the perfect component.
Maybe setting a bunch of IB_Query properties you can use it as well,
but this is a non-sense (use the right tool ;))
You could also use IB_Monitor to see what's the output of the two
components, perhaps the same statement requires a different syntax in
IB_Query (i.e. execute...).
Just some thoughts
best regards
Marco Menardi

--- In IBObjects@y..., "Alan McDonald" <alan@m...> wrote:
> Why does IB_DSQL execute this statement
> alter index INDEXNAME active
> But IB_Query comes back with a permissions error on the table to
which the
> index applies
> ?
> Perhaps there's a subtlety in IB_Query setup which I'm not aware
of... I can
> do this with IBQuery (IBX) no problem.
>
> thanks
> Alan