Subject | Re: [firebird-support] IS NULL and query parameters |
---|---|
Author | Helen Borrie |
Post date | 2004-07-28T14:01:42Z |
At 07:53 PM 26/07/2004 +0200, you wrote:
What's wrong with
WHERE aValue = ? OR aValue IS NULL
??
/heLen
>Hello:Why would you try to do this? Null isn't a value.
>
>I want to know if there are any special reason
>why Firebird doesn't allow to check for nulls
>in query parameters by doing:
>
> ? IS NULL
>
>It raises the exception:
>
>Dynamic SQL Error.
>SQL error code = -804.
>Data type unknown.
>
>when preparing the command.
What's wrong with
WHERE aValue = ? OR aValue IS NULL
??
/heLen