Subject Re: [firebird-support] Problem with query parameter
No it isn't possible, which is what the error is telling you.
You can't select anything from a table based on a parameter you are
setting if that parameter is null. What do you expect back??
If you want a set of records where their value is null, then "select *
from atable where afield is null" will work.

Alan J Davies

Quoting Harriv <harriv@...>:

> I'm trying to do something like this:
> select * from TABLE
> where FIELD = :param or :param is null
> When executing that, I get "Dynamic SQL Error SQL error code = -804 Data
> type unknown" error. Should the above statement even be a possible?
> [Non-text portions of this message have been removed]