B4J Question SQLite [Resolved]

[Sergey_New]

If there is an apostrophe in the string, an error occurs. How to pass the string value correctly?

Dim key As String="I1"
Dim str As String="d'Ydewalle"
db.ExecNonQuery("INSERT INTO names (id, name) VALUES ('" & key & "', '" & str & "')")

 

[LucaMs]

Use db.ExecNonQuery2

(read the contextual help)

 

[Sergey_New]

Thanks!
I've never used parameterized queries .
Please write the correct code.

 

[LucaMs]

Dim key As String="I1"
Dim str As String="d'Ydewalle"
db.ExecNonQuery2("INSERT INTO names (id, name) VALUES (?, ?)", Array(key, str))

 

[Sergey_New]

LucaMs, thanks!

 

[AnandGupta]

@Sergey_New please mark Lucas post as solved.
This will help in future.

 

[Sergey_New]

Anand, done