General information
Title:
Problem with SQL UPDATE via SQLEXEC
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
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