S Sergey_New Well-Known Member Licensed User Longtime User Dec 25, 2021 #1 If there is an apostrophe in the string, an error occurs. How to pass the string value correctly? B4X: Dim key As String="I1" Dim str As String="d'Ydewalle" db.ExecNonQuery("INSERT INTO names (id, name) VALUES ('" & key & "', '" & str & "')")
If there is an apostrophe in the string, an error occurs. How to pass the string value correctly? B4X: Dim key As String="I1" Dim str As String="d'Ydewalle" db.ExecNonQuery("INSERT INTO names (id, name) VALUES ('" & key & "', '" & str & "')")
Solution LucaMs Dec 25, 2021 B4X: Dim key As String="I1" Dim str As String="d'Ydewalle" db.ExecNonQuery2("INSERT INTO names (id, name) VALUES (?, ?)", Array(key, str))
B4X: Dim key As String="I1" Dim str As String="d'Ydewalle" db.ExecNonQuery2("INSERT INTO names (id, name) VALUES (?, ?)", Array(key, str))
LucaMs Expert Licensed User Longtime User Dec 25, 2021 #2 Use db.ExecNonQuery2 (read the contextual help) Upvote 1
S Sergey_New Well-Known Member Licensed User Longtime User Dec 25, 2021 #3 Thanks! I've never used parameterized queries . Please write the correct code. Upvote 0
LucaMs Expert Licensed User Longtime User Dec 25, 2021 #4 B4X: Dim key As String="I1" Dim str As String="d'Ydewalle" db.ExecNonQuery2("INSERT INTO names (id, name) VALUES (?, ?)", Array(key, str)) Upvote 1 Solution
B4X: Dim key As String="I1" Dim str As String="d'Ydewalle" db.ExecNonQuery2("INSERT INTO names (id, name) VALUES (?, ?)", Array(key, str))
AnandGupta Expert Licensed User Longtime User Dec 25, 2021 #6 @Sergey_New please mark Lucas post as solved. This will help in future. Upvote 0