Hi. I have a database in SQLite format and I need to do a partial search with a certain text. I would like to know what is the correct way to do it, since I have tried LIKE '%text%' but apparently does not yield results. Also, I used the UPPER (text) function to simplify the search.
This Code does not produce errors, but neither results.
Dim DLG as InputDialog Dim SQL1 as SQL Dim Cursor1 as Cursor '.... SQL1.Initialize .... '.... DLG.Show '.... DESC is a TEXT field in MARKERS table '.... Bla bla bla Cursor1 = SQL1.ExecQuery("SELECT LAT, LON, DESC FROM MARKERS WHERE UPPER(DESC) LIKE '%" & DLG.Input.ToUpperCase & "'%")