I have problem in updating a text field of SQL Server using ODBC from the content of Visual FoxPro 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 Visual FoxPro memo contains backwards slash followed by chr(13) or chr(10).

How can I update such memo content to SQL text field?


Thank you for any help.


This is a MS SQL bug.

WORKAROUND: Convert the memo to a char type,
with a char parameter, VFP use a ODBC parameter and the SQL Parser not scan the literal string.

update table set sqltext = ?(vfp8.memofield+'')