Luiz,

Thanks for your reply.

I thought this was not the recommended way of building your SQL.

Isn't the preferred way of building your queries and using stored
procedures was by binding parameters?

By binding parameters with your query will cache the prepared query
for reuse later.

I still cannot understand why does it not allow me to set the Param
on the BeforeOpen event?

John.

--- In IBObjects@y..., "Luiz" <cprmlao@i...> wrote:
> You can get rid off the parameter and OnPrepareSQL event do:
>
> qry.sqlwhereitems.add('Value='+inttostr(your_int_value))
>
> Luiz.
>