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+'')