>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"
Mark McCasland
Midlothian, TX USA