i have string that contains apostrophe and comma's and when i excute insert into SQLight it gives me error for example with string like this :
@...., 'The Smiths - I Know It's Over', .....
"Over": syntax error Unable to execute statement@
how can i or what can i do to keep the apostrophe's in the string but preform valid insert? .
im using simple :
@QString InsertSqlStst =" INSERT ......"
ret = query.exec(InsertSqlStst);@