RowFilter of Dataview object ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I am using a dataview windows application object
Form that I need to set the RowFilter property in order to view data based
on two different columns values.

Querry string is as follow :

m_sSeverityFilter = m_dsHist.Tables(0).Columns(4).ColumnName & " = " & "'" &
cbSeverity.Text & "'"

m_sCommentFilter = m_dsHist.Tables(0).Columns(6).ColumnName & " <>''" (need
to filter here column fileds which are not null or empty string)

Base on that it works fine as long as I work only one of those criteria but
as soon as I used both condions I get a sythax error that I could not pointed
out why

DataView.RowFilter =m_sCommentFilter & "," & m_sCommentFilter

ANy ideas where is the error?

thnaks for your help
regards
serge
 
Serge,

As Bill told do you have to use the AND (and not the &).
As well is this filter one continuous string and not two strings.

I hope this helps,

Cor
 
Back
Top