>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 ' "
lcSqlString=strtran(lcSqlString, ['], [''])
I.e., replace each apostrophe with two apostrophes.
Quotation marks (chr(34)) can be left as they are.