iOS Question Tableview issue

[DeclanOK]

The following is failing to fill the table with the values
The Log shows values are all there

Sub TextField1_TextChanged (OldText As String, NewText As String)
 TableView2.Clear
 Log("Text change")
 NewText = NewText.Trim
 If NewText.Length >2 Then
  Log(NewText)
  Dim rs2 As ResultSet= MyDataBase.ExecQuery("Select * from NEW_TABLE where _id like '" & "%" & NewText & "%' ORDER by _id")
  'If rs2.NextRow Then
  Dim topicy As String
  Dim i As Int
  i=0
  Do While rs2.NextRow
   i=i+1
   topicy = rs2.GetString("_id")
   Log(topicy)
   TableView2.AddSingleLine(topicy)
   Page2.Title = i & " Relevant Topics" & " in " & topic
  
  Loop
 End If
End Sub

 

[Erel]

1. You are not closing the ResultSet.
2. You should use a parameterized query.
3. Call TableView.ReloadAll at the end.