Double & Single quotation marks issues (1 Viewer)

FuzMic · Nov 21, 2018

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.

June7 · Nov 21, 2018

Have to 'escape' the special character. This is accomplished by doubling the character. I use Replace function to handle this:

Replace(Var1$, "'", "''")

You don't need the SELECT if you don't specify a table with FROM. I don't see how this can work anyway without FROM clause.

"INSERT INTO Tbl1 ( Txt ) VALUES('" & Replace(Var1$, "'", "''") & "'"

FuzMic · Nov 21, 2018

Thank you June, i feel it will work. I will try it.

i learn something new about VALUES, thanks for that. Cheer!

FuzMic · Nov 21, 2018

June

the Replace works out but

VALUES part flag syntax error, any reason

June7 · Nov 21, 2018

Sorry, forgot end ) for the VALUES clause.

& "')"

FuzMic · Nov 21, 2018

Ya I also missed that should work, &#55357;&#56397;

Double & Single quotation marks issues (1 Viewer)

FuzMic

DataBase Tinker

June7

AWF VIP

FuzMic

DataBase Tinker

FuzMic

DataBase Tinker

June7

AWF VIP

FuzMic

DataBase Tinker

Similar threads

Users who are viewing this thread