moore_it Active Member Licensed User Feb 16, 2015 #1 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
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 Administrator Staff member Licensed User Feb 16, 2015 #2 Always use ExecuteNonQuery2. B4X: SQL.ExecuteNonQuery2("INSERT INTO tablename VALUES (?)", Array("caffe'"))
Always use ExecuteNonQuery2. B4X: SQL.ExecuteNonQuery2("INSERT INTO tablename VALUES (?)", Array("caffe'"))