Android Question How to use character esc \ or / in sqlite ?

[Ajws]

Hi all,
help...
how to save character esc / or \ in sqlite database ?


thank y

 

[Erel]

Always use parameterized queries and you will never need to escape anything:

SQL1.ExecNonQuery2("INSERT INTO table1 VALUES (?, ?)", Array("some text", ",./,'"))

 

[Ajws]

yes...thank you Erel,
how about update query ? How can i implement it ?

 

[Erel]

SQL1.ExecNonQuery2("UPDATE table1 SET column1 = ?, column2 = ? WHERE column3 = ?", Array(x, y, z))