Larry,

Try this:

SQLEXEC(handle,"update clmlog set descrip=?lcMyVar where recno()=13"

The question mark indicates a parameter in the where clause. I'm not sure it will work here, but it's worth a try.

>>>>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.
>>
>>What is the backend database engine? VFP? You might try running the debugger and trace the value of _screen.ActiveForm.edbDescrip.Value to make sure it has a correct value.
>
>I didn't finish my reply, sorry. Let me finish by saying that I've tried looking at just about everything with the debugger. I've tried changing my approach to getting the value, even changing variable name, switching the single and double quotes around, name it, I've probably tried. <g>