Android Question Use Variable in SQL Where Clause

[Startup]

How can I use a variable in a SQL where Clause?

The following code works ok with the where clause containing a literal -

Cursor1=SQL1.ExecQuery("SELECT number from testtable where word = 'house'")

but the following code with the same literal in a variable (wordselectstring) produces an error -

Cursor1=SQL1.ExecQuery("SELECT number from testtable where word = wordselectstring")

Here is the code which I used to create the literal in the variable. The log shows the variable wordselectstring contains the literal 'house'

Dim wordselect As String
wordselect="house"
Dim wordselectstring As String
wordselectstring ="'" & wordselect & "'"
Log(wordselectstring)

 

[DonManfred]

Cursor1=SQL1.ExecQuery("SELECT number from testtable where word = wordselectstring")

try it with

Cursor1=SQL1.ExecQuery("SELECT number from testtable where word = "&wordselectstring)

You cannot put variables in a string...

 

[mangojack]

or use the .ExecQuery2 method ..

Cursor1=SQL1.ExecQuery2("SELECT number from testtable where word = ?",Array As String(wordselect))

 

[Erel]

You cannot put variables in a string...

Not 100% correct: https://www.b4x.com/android/forum/threads/50135/#content

However you should use ExecQuery2 as @mangojack wrote.

 

[DonManfred]

Not 100% correct

yes, with the string literal it works... But you you need to use a ${}-Command to include a variable into the literal

 

[Startup]

or use the .ExecQuery2 method ..

Cursor1=SQL1.ExecQuery2("SELECT number from testtable where word = ?",Array As String(wordselect))

That does it. Thanks!