> If I have a parameterized query as:
> 'select first ?par1 * from table'
>
> Which is the better event on tib_query to plug values into 'par1'

parameter?

> Is OnAfterPrepare, OnPreapreSQL or there is another?

First of all, I have no idea if a parameter is acceptable there. If it is
then you should use it just as you would any other input parameter.

You don't assign parameter values in the OnPrepareSQL event because the
statement isn't prepared yet.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com