barryr

barryr

  • NA
  • 10
  • 0

RowFilter Compound Expression Problem

Mar 15 2005 4:19 PM
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

Answers (4)