FuzMic
DataBase Tinker
- Local time
- Tomorrow, 05:40
- Joined
- Sep 13, 2006
- Messages
- 719
Hi gals / guys
I use the following to append in a table, Tbl1
"INSERT INTO Tbl1 ( Txt ) SELECT '" & Var1$ & "' AS Cs;"
As you can see the Var1$ as a string. In the query there it is quoted with a single quote before a double quote.
The issue: if var1$ also contain a single quote eg House's flies, then append query will no execute.
Any suggestion to solve this. My current way is to avoid any single quote in the Var1$, not so smart.
I use the following to append in a table, Tbl1
"INSERT INTO Tbl1 ( Txt ) SELECT '" & Var1$ & "' AS Cs;"
As you can see the Var1$ as a string. In the query there it is quoted with a single quote before a double quote.
The issue: if var1$ also contain a single quote eg House's flies, then append query will no execute.
Any suggestion to solve this. My current way is to avoid any single quote in the Var1$, not so smart.