How to deal single quote in filename path ?? (Android SQLite)

Question

ERROR : near "s": syntax error (code 1): , while compiling: DELETE FROM 'sp_downloadfile' WHERE filename='It's Easy to be Happy'

Here` DELETE FROM 'sp_downloadfile' WHERE filename='It''s Easy to be Happy'` — Ed Bangga, Dec 26 '19 at 08:48
Does the literal value is inserted into the query text directly or like a parameter? When directly then double each inner quote, when like a parameter then wrap it with REPLACE() function which will replace each single quote with doubled one. — Akina, Dec 26 '19 at 08:55

score 1 · Answer 1 · edited Dec 26 '19 at 08:50

1

edited Dec 26 '19 at 08:50

Saurabh Thorat

answered Dec 26 '19 at 08:49

hoangnh

thanks dude, i think this is the easiest one – Exel Staderlin Dec 26 '19 at 09:25

1 Answers1