>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
To my understanding RECNO() is not available in SQL SERVER.