Subject Re: [IBO] Parameterized WHERE clause
Author Luiz
You can use OnPrepareSQL to achieve it. But, you need still use
invalidatesql to flag the query to reprepare.


----- Original Message -----
From: "ehandbury" <ehandbury@...>
To: <>
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:
> and I leave the ACTIVITYKEY param empty, will it be ignored?
> TIA. Eric.