When filtering a Delphi TDataSet is there a difference between the NULL and BLANK keywords?

Asked May 21 '13 at 16:24

Active May 21 '13 at 16:24

Viewed 1,576 times

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?

asked May 21 '13 at 16:24

Hobo Joe

3

BLANK = Empty String http://www.informit.com/articles/article.aspx?p=24094&seqNum=8 – bummi May 21 '13 at 16:31
1

@bummi: Excellent. If you enter as an answer I'll mark it as correct. – Hobo Joe May 21 '13 at 16:35
I wonder if TDataSet obeys server rule for `'' IS NULL`... – OnTheFly May 21 '13 at 20:35

0 Answers0