Need help with DBUtils.ExecuteListView parameter for the WHERE clause

[rleiman]

Hi Everyone,

I would like to use the value from an EditText box to filter a ListView.

Can you look at my coding and let me know what else I need to do to get it to work?

So far it only returns 0 rows.

Sub ButtonSearchFilterEventHandler_Click
   
   ' Populate the list.
   '-------------------
   DBUtils.ExecuteListView(SQL, "SELECT Id, ResultDescription " & _
                           "FROM VisitResultTypes " & _
                           "WHERE ResultDescription = ? " & _
                        "ORDER BY ResultDescription", _
      Array As String(EditTextResultDescription.Text), 0, ListViewResults, True)
End Sub

Thanks.

 

[vb1992]

"WHERE ResultDescription like ? " &

might help..



also fool around with the wildcards which is most likely %

ex: select * from tablename where name like '%kim%'

 

[rleiman]

Hi vb1992,

Thanks for the reply.

I used this and it worked.

   DBUtils.ExecuteListView(SQL, "SELECT Id, ResultDescription " & _
                           "FROM VisitResultTypes " & _
                           "WHERE ResultDescription LIKE " & "'" & EditTextSearchFilter.Text & "%' " & _
                        "ORDER BY ResultDescription", _
      Null, 0, ListViewResults, True)