>>ccmd = "update clmlog set descrip='" + thisform.edbDescrip.value +; "' where recno()=13"
>....however, one or more carriage returns within the control gives me an odbc error "37000
>
>Larry, I think that the problem is that a CR within the contents of the editbox can confuse the ODBC parser..
>
>I'm curious, about one thing. After doing your update using a parameterized query (i.e., with the ?SomeMemlVar construct), are the carriage returns actually stored in the table that you update, or have they been replaced with some other character?
You're question sparked some curiosity in me also so I checked and it did store the carriage returns as such.
In response to the ODBC parser, I created a line of text similar to what was giving me problems including carriage return/line feed characters (this was before I asked for help here) and the parser accepted it with no problem. This is what prompted me to see if anyone here had experienced anything like this. It was confusing to me that assigning the value of the control to a variable didn't alleviate the problem. It was as if the value of the variable wasn't a value at all but more like a pointer to a pointer to a value and that the odbc parser didn't understand how to dereference this value. That is my theory but I've also asked Microsoft about this and I hope to get an answer soon.
Thanks everyone for your quick responses!
Larry
Previous
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