I choose to use parameters in this case cause I think it would perform
better instead of having to reprepare the query every time the parameter
change.

PS: A propósito, de que lugar do Brasil você é?

Claudio F. Kloss
MicroLight Informática Ltda.
Juiz de Fora - MG - Brazil

-----Mensagem original-----
De: Luiz Alves [mailto:cprmlao@...]
Enviada em: terça-feira, 27 de fevereiro de 2001 17:33
Para: IBObjects@yahoogroups.com
Assunto: Re: [IBO] Better place to change Params

Another alternative is:

If you can use this query without parameters on sql statement, you could
code onPrepareSql event with SQLWhereItems to filter that rows.

I use it all the time.

Luiz.