ADO reading parameters into SQL
I am sending some sql to Oracle which has double quotes inside a text string, fine no problem. However if there is a colan inside the double quotes then ADO throws a exception. The exception it thro...
Forum Discussion
Hi Chris,
Have you tried to escape the colon character in your query by using the backslash character before the colon? Please try to use the following code:
I'm not sure about this, but I hope, this can help in your case if you need the colon character to be interpreted just as the colon character in the sought-for string.
Have you tried to escape the colon character in your query by using the backslash character before the colon? Please try to use the following code:
Qry.SQL = "select '\" \: \"' as text from dual";
I'm not sure about this, but I hope, this can help in your case if you need the colon character to be interpreted just as the colon character in the sought-for string.
