firebird-odbc-devel

[Firebird-odbc-devel] Date and NULL values in select

[Gunnar <gu...@no...>]

Hi,

First of all, thanks for solving my other date-problem.
I appreciate very much the work all of you are doing to make a odbc-driver.

So to my question.
In my application I have to check for the existence of a date value.
In the odbc trace this is translated to

  WHERE (  A.TRANSDATE > NULL )

and if I am checking for a NULL value

  WHERE (  A.TRANSDATE = NULL )

which I know is not legal sql and is rejected.

Anyway, would it be possible to implement this kind of call and if so, has 
this to be done in the odbc driver or in the database backend?

Regards

Re: [Firebird-odbc-devel] Date and NULL values in select

[Vladimir T. <pr...@hm...>]

Hello,

>
> So to my question.
> In my application I have to check for the existence of a date value.
> In the odbc trace this is translated to
>
>   WHERE (  A.TRANSDATE > NULL )
>
> and if I am checking for a NULL value
>
>   WHERE (  A.TRANSDATE = NULL )
>
> which I know is not legal sql and is rejected.
>
> Anyway, would it be possible to implement this kind of call and if so, has
> this to be done in the odbc driver or in the database backend?

Probably I not correctly have understood a question, but you should use

         WHERE (  A.TRANSDATE IS NULL )
    or
         WHERE (  A.TRANSDATE IS NOT NULL )

--
Best regards,
Vladimir Tsvigun