General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
CR & LF through ODBC
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only