>>I've been fighting this problem for several hours and I'm getting no where. I hope someone out there can help. Basically I have the exec string being built as follows:
>>ccmd = "update clmlog set descrip='" + thisform.edbDescrip.value +; "' where recno()=13"
>>
>>iErr = sqlexec( iConn, ccmd )
>>
>>The edbDescrip control is an editbox and if there are no carriage returns within it then this works fine, however, one or more carriage returns within the control gives me an odbc error "37000 - Command contains unrecognized phrase/keyword" when submitted to the sqlexec function. Does anyone have any ideas?
>>
>>Thanks,
>>Larry Wainwright
>
>try storing thisform.edbDescrip.Value to a variable first
>
>ccmd = "update clmlog set descrip='" + lcMyVar + "' where recno()=13"

I did try this. Also, I duplicated what the entry was going to be in the code along with the carriage returns and this worked just fine. I am so... at a loss.