Error near ': there is a ' character in a field

Databases
1

In a SQLIte SQLExecute ("UPDATE … ") line, I get sometimes an error near '…

The user sometimes type a ’ in a field I pas as is. Is the following correct ? (it Compiles but crashed on a different location)

ReplaceAll(TF_SentBy.Text,"'","\\'")

I just checked in the internet before a click in Start Conversation and I found an entry at http://stackoverflow.com that says so (for Android). Is it OK for Xojo ?

2

Please use prepared statements. Than you don’t need Replaceall.

3

I was thinking… I already use it. I may forgot to add it in that part. I will check.

Thank you Christian.

4

Christian:

you were right: I do not added Prepared Statements there ! I will and while I am at it, I will check other parts of the project and add where needed. I certainly had a break the day I add Prepared Statements (a phone call, someone at my door but not at my window :-{, etc.) .