Subject Parameterized WHERE clause
Author ehandbury

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.