Can you post code that executes this update statement?

>I have a Add-In running in Outlook that automatically updates a VFP database when emails are sent and received. I update a memo field with a long string containing the address, sent/received date and time, subject and body. I've tried to insert carriage returns and line feeds by inserting this string between the values: "+chr(13)+chr(10)+".
>
>So, the update statement that gets generated looks like so:
>

>update MyNoteTable set notetext=notetext+chr(13)+chr(10)+chr(13)+chr(10)+'Email was sent on 12/19/2004 21:10:12 PM"+chr(13)+chr(10)+"To: nate@climark.com"+chr(13)+chr(10)+"From: nate@climark.com"+chr(13)+chr(10)+"Subject: subject text"+chr(13)+chr(10)+"Body Text' where serialid='000264381876'
>
>The text that ends up being updated in the VFP table has the literal version of this; that is the chr(13)+chr(10) is ending up as "chr(13)+chr(10)", rather than a carraige return and line feed.
>
>This update statement is passed through an VFP OLEDB connection. This works just fine if issued from within VFP, but when passed in via the OLEDB connection the carriage returns are not inserted. I've tried the same thing using the .Net version of crlf "\r\n". That just causes the select statement to fail when being passed to the ADO Connection.
>
>Anyway, has anyone else had to insert CRLFs in an update or insert statement like this? Does anyone have any ideas?
>
>Thanks in advance for your help.
>
>-Nate