Filter string for TDateTime field - TCRDBGrid

[ertank]

Hi,

I am using MSSQL Express as a database. I have a TCRDBGrid which its columns are dynamically set during run-time. One of the columns linked to a "date" datatype field on MSSQL.

There are some records with "date" field set to NULL in the MSSQL database. I want my users to be able to filter NULL records (or empty records) for a "date" field using provided CRDBGrid filter property at run-time. Is this possible? If yes, what should filter string look like?

[AlexP]

Hello,

In order to filter by empty (NULL) fields, you should add the NULL word in the filter field.

[ertank]

My bad. Both upper case and lower case NULL is working. I hit another bug explained here.

http://forums.devart.com/viewtopic.php?f=28&t=33025

That's why my trials were producing error messages. Modified column names and all good now.

Thanks.

[AlexP]

Glad to see that you solved the problem. If you have any other questions, feel free to contact us