Subject | conditional where clause |
---|---|
Author | Cornel Rebegea |
Post date | 2006-12-15T14:18:46Z |
Hi, I have one question to I couldn`t find the answer despite my
searching.
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.
searching.
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.