[Gambas-user] DB.Quote() doesn't quotes apostrophes

[Caveat]

Why not just process one term at a time?


  Dim conn As Connection
  Dim termStr As String
  Dim terms As String[]
  Dim enteredTerm, escapedTerm As String

  ...
  conn = DataAccess.getConnection()
  ...
  ' Get termStr from the input box  
  'termStr = txtQueryInput.Text
  
  ' Set termStr manually for testing
  termStr = "abc def he's fill kill''d fine &1 %2 it's%"

  terms = Split(termStr, " ")
  For Each enteredTerm In terms
    escapedTerm = DB.Subst("&1", enteredTerm)
    ' do something with the escaped term... 
    ...
  Next

Kind regards,
Caveat