Hi
I am working with rowfilters in dataviews.
I would like to filter for empty fields (= null value in the database)
I found this sentence on msdn:
****************
To return only those columns with null values, use the following expression:
"Isnull(Col1,'Null Column') = 'Null Column'"
*************************'
So I tried like this:
mainDataSource.RowFilter = "Gender = 'male' and " & "Isnull(floor,'Null
Column') = 'Null Column'"
And this actually works returning males that does not have a value in the
floor field.
But I do not understand why.
Isnull returns a boolean and does not take a column and a string. It looks
more like the NZ function from visual basic.
Can someone explain this to me?
Best regards
Jan