Peter,
I run tests in VFP8SP1 and VFP9beta and not only '\' disapeared but CHR(13)/CHR(10) following it disspeared too. Looks like a bug to me. You can report it at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;867477.
You can work around it by assigning memo field to a memory variable and using that variable in UPDATE.
lcStr = vfp8.memofield
update table set sqltext = ?lcStr
>I have problem in updating a text field of SQL Server using ODBC from the content of VFP memo field if the content of the memo contains this:
>
>ABC\
>TEST
>
>Note: There is a chr(13) after \.
>
>If I issue statement like this:
>
>update table set sqltext = ?vfp8.memofield
>
>The text field will contain:
>
>ABC
>TEST
>
>
>The backwards slash will disappear. This happens only if the VFP memo contains backwards slash followed by chr(13) or chr(10).
>
>How can I update such memo content to SQL text field?
>
--sb--