Try this instead:
l_cSQL="UPDATE chronology SET cchronitem= ?l_cNotes WHERE nchronkey=1"
The ? tells VFP to send the data in the variable. It handles every thing else for you.
>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