You can use OnPrepareSQL to achieve it. But, you need still use
invalidatesql to flag the query to reprepare.

Luiz.

----- Original Message -----
From: "ehandbury" <ehandbury@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 15, 2002 9:07 PM
Subject: [IBO] Parameterized WHERE clause


> Hello,
>
> I have a WHERE clause for a form as follows:
> ... WHERE AMODE=0 ...
>
> Occasionally, I need to change the WHERE clause to get a single row
> as follows:
> ... WHERE ACTIVITYKEY=<Some Integer> AND AMODE=0 ...
>
> Right now I clear the TIB_Query SQL and add the new SQL statements.
> But I understand that IBO has to prepare the statement again.
>
> Is there any way to parameterize this WHERE clause so it only gets
> prepared once and I don't have to re-enter the SQL?
>
> If I have the following parameterized statement:
> ... WHERE ACTIVITYKEY=:AKEY AND AMODE=0 ...
>
> and I leave the ACTIVITYKEY param empty, will it be ignored?
>
> TIA. Eric.
>