I've come across a problem trying to update a memo field through ODBC.

l_cNotes="This is test one"+CHR(10)+CHR(13)+"This is test two"
l_cSQL="UPDATE chronology SET cchronitem='"+l_cNotes+"' WHERE nchronkey=1"
iResult=SQLEXEC(g_cSystemConnect,l_cSQL,l_cCursor)

The update fails with this message:

"Command contains unrecognized phrase/keyword"

Without the CR & LF it works fine. Is there a function to encode the CR & LF?

TIA,

/Chris