General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks Josh,
I tried ? orgionally but got an error, must have been another syntax problem.
/Chris
>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
Previous
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