H Hodi Member Licensed User Longtime User May 29, 2012 #1 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
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 B4X founder Staff member Licensed User Longtime User May 29, 2012 #2 Yes. You should use LIKE instead of MATCH: Code: Copy DBUtils.Executelistview(SQL1, "SELECT col1, col2 FROM Table1 WHERE Col1 LIKE '%" & Search & "%'", Null, 0, Listview1, True) Upvote 0
Yes. You should use LIKE instead of MATCH: Code: Copy DBUtils.Executelistview(SQL1, "SELECT col1, col2 FROM Table1 WHERE Col1 LIKE '%" & Search & "%'", Null, 0, Listview1, True)
