DataView RowFilter does not work with mulitple conditions

[Mike Kline]

Hi There!

I'm on .NET framework 1.1 with .NET framework SP1. My OS is Windows XP with
SP2.

I have the RowFilter property of the DataView set to...

"[column_one] <= 2 AND [column_two] >= 4"

But I didn't get the filtered result set, instead I get all the results from
the table unfiltered. So I checked the DataView.RowFilter property
immediately after I set the filter and it return "True" instead of the
filter condition "[column_one] <= 2 AND [column_two] >= 4".

However, if I set the condition to just "[column_one] <= 2", then it works.
Only when I do multiple conditions, it changes the RowFilter to "True" and
return all the rows from the table without filtering.

What I'm missing here?

Thank you all in advance!!!
MK

 

[Mike Kline]

Forget it, I found the error. Forgot to put the double quotes on literal
strings

MK

 

[W.G. Ryan eMVP]

Here's an example where I use multiple conditions as well as functions in
them http://www.knowdotnet.com/articles/advancedrowfilter.html
Can you show the actual value you're using?