DBUtils - Parse SQL and show result in LV

[Hodi]

Hi All,


I want to find a number in my Sql database with a edittext and want to
show the results in Listview.

Is it possible to do this...

Sub Edittext1_EnterPressed
Listview1.Clear
Dim Search As String
Search = Edittext1.Text
DBUtils.Executelistview(SQL1, "SELECT col1, col2 FROM Table1 WHERE Col1 _ MATCH '" & Search & "*'", Null, 0, Listview1, True)

Thanks for your feedback....
Hodi

 

[Erel]

Yes. You should use LIKE instead of MATCH:

DBUtils.Executelistview(SQL1, "SELECT col1, col2 FROM Table1 WHERE Col1 LIKE '%" & Search & "%'", Null, 0, Listview1, True)