iOS Question SQL insert

[moore_it]

Hello everybody,

how i do to insert a field in a sqlite db table when i found an " ' " char ?

example ...

INSERT INTO tablename VALUES ('caffe'')

Thanks in advice
Toni

 

[Erel]

Always use ExecuteNonQuery2.

SQL.ExecuteNonQuery2("INSERT INTO tablename VALUES (?)", Array("caffe'"))

 

[moore_it]

Try it,
thanks Erel !