At 09:35 AM 6/04/2004 +0000, you wrote:

>Hi,
>
>I have following SQLWhereItems code :
>
>if .......... then
> SQLWhereItems.Add('DATE_IN IS NOT NULL')
>else
> SQLWhereItems.Add('DATE_IN IS NULL');
>
>Problem is : the IS NOT NULL part is working well, but IS NULL part
>doesn't retrieve any records. I checked in the DB and the values are set
>to NULL.
>Is there a better syntax for EMPTY dates ?

No, there is no syntax other than null for empty dates. I think what you
need to do for those columns is set their BlankIsNull property to
true. I'm not sure whether this has been fixed, it was a little bug from a
while ago...

Alternatively, if that doesn't do it (and it might be an issue of
parsing-level) you could try make the condition ('DATE_IN IS NULL OR
DATE_IN <= 0'). This would not be safe if you were testing dates earlier
than date zero (which is something around 17 November 1899 in InterBase,
AFAIR).

What version of IBO are you using?

Helen