RowFilter Compound Expression Problem
anyone got an idea why this won't work:
dataView1.RowFilter = "ID NOT IN(" + ErrorString + ") or " + "Description LIKE '%" + KeywordFilter2 + "%' or " + "Name '%" + KeywordFilter2 + "%' or " + "Place '%" + KeywordFilter2 + "%'";
this works fine:
dataView1.RowFilter = "ID NOT IN(" + ErrorString + ")"
as does this:
dataView1.RowFilter = "Description LIKE '%" + KeywordFilter2 + "%' or " + "Name '%" + KeywordFilter2 + "%' or " + "Place '%" + KeywordFilter2 + "%'";
but not together. Error string contains a string of type a,b,c.....
cheers
barry