Android Question [SOLVED] How to use smart string literal with SQL

[stanks]

for example i have some stuff in list. i have 2 types of values. numbers and string. numbers are integers only. strings are not only characters but i have /, ?, etc. (like web links).

example:

listNumbers, listNames and listL are the same size

For i = 0 To listNumbers.Size - 1
  sql1.ExecNonQuery($"INSERT INTO lTest VALUES(2, ${listNumbers.Get(i)}, ${listNames.Get(i)}, 1, ${listL.Get(i)}, 1)"$)

with this code i always get error

    (near "kolo": syntax error (code 1): , while compiling: INSERT INTO lTest VALUES(2, 1, kolo1 - kolo2, 1, /456/234/44?xx=2, 1))

any idea?

thanks

p.s. Logging of above statement gives correct string for inserting

 

[stanks]

with array works ok...

 

[Geezer]

Try using ExecNonQuery2

 

[npsonic]

For i = 0 To listNumbers.Size - 1
  sql1.ExecNonQuery($"INSERT INTO lTest VALUES(2, '${listNumbers.Get(i)}' , '${listNames.Get(i)}' , 1, '${listL.Get(i)}' , 1)"$)

 

[stanks]

oh so i am missing ' .... ok thanks. will try this

 

[Erel]

The correct answer is to use ExecNonQuery2.

sql1.ExecNonQuery2($"INSERT INTO lTest VALUES(2, ? ,? , 1, ? , 1)"$, Array As String(listNumbers.Get(i), ...))

Watch the SQL databases video tutorial: https://www.b4x.com/etp.html

 

[mangojack]

The correct answer is to use ExecNonQuery2.

sql1.ExecNonQuery($"INSERT INTO lTest VALUES(2, ? ,? , 1, ? , 1)"$, Array As String(listNumbers.Get(i), ...))

Small correction .. should be

sql1.ExecNonQuery2($"INSERT INTO lTest VALUES(2, ? ,? , 1, ? , 1)"$, Array As String(listNumbers.Get(i), ...))