Subject Re: [firebird-support] conditional where clause
Author Ivan Prenosil
> How can you make a conditional where clause in Firebird ?
> I will give you an example of what I am used to do in Foxpro:
> Select *
> from Table
> where iif(:pcond, Table.field = :par1, True)
> that is, if param pcond is true than inforce condition Table.field =
> :par1, else no filter.

What type is pcond ? If it contains 0/1 for true/false, then use

where :pcond=0 or Table.field = :par1