Hobo Joe
Reputation: 181
When filtering a Delphi TDataSet is there a difference between the NULL and BLANK keywords?
When using the Filter property of TDataSet I enter the following filters:
'State <> ''CA'' or State = BLANK'
'State <> ''CA'' or State = NULL'
Does BLANK mean empty but not null or are they equivalent or are there other differences between these two filters?
Upvotes: 2
Views: 1783
Answers (0)
Related Questions
- Visibility of filtered out records in TDataSet OnFilterRecord event
- DataTable Rowfilter syntax for rows where a column is null or empty
- Difference between NULL and NULL("") in DML
- What is the exact effect of TDataset.close() in Delphi?
- Difference between Null and Empty String in Delphi 7 and Delphi XE4
- How do i get a TDataset to store empty string instead of null?
- Refresh dataset when applying a filter
- Handling T-SQL Query with null filters as parameters
- behavior of <> to filter null values
- Check at TDataSet row against a filter string