Is this a known problem in updating SQL text field with memo?

[pctest]

I notice that if I update a SQL text field with a VFP8 memo field and the content of the memo is something like:

ABC\
TEST

Note: After the \, there is a chr(13).

The SQL text field will become:

ABC
TEST

The backwards slash will disappear. The problem only occurs when the \ is followed by chr(13).

Thank you for any help.

 

[rgbean]

What version of SQL server are you running? Are you using ODBC or ADO to update the SQL table? What version of MS SQL ODBC or ADO driver are you using?

Rick

 

[pctest]

I'm using SQL Server 2000. Using ODBC and VFP8 SP1. I forget how to find out the version of ODBC. The SQLSRV32.dll is 2000.85.1117.00.

 

[craigsboyd]

What effect does doubling the backslash have ("\\")?

http://www.sweetpotatosoftware.com