>VFP6 SP5. Using sqlexec() to insert records into SQL server database. How to allow "'" or quotes to be entered?
>The syntax use is :-
>lcsqlstring = "Something with ' "
>Thanks in advance.
>Yau
I don't know for sure about sqlexec(), but usually, to include quotation marks in a string, you can use another kind of quotation marks on the outside. There are three kinds of "quotation marks" for strings in VFP:
"string"
'string'
[string]
So, for example, if you need double quotation marks, you can use any of the other one:
'A string with "quotation marks"'
or:
[A string with "quotation marks"]
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)