Hi,

I have a problem with SQLWhereItems, here is a part of the code :

if.............. then
SQLWhereItems.Add ('DATE_IN IS NOT NULL')
else
SQLWhereItems.Add ('DATE_IN IS NULL')


The NOT NULL part is working well, but the IS NULL part is not working, even
the values in the database are set to NULL. The query is not retrieving
any records. Is there a better syntax for EMPTY dates ?

Thanks in advance,

Nico Callewaert