Josh,
That was a great idea. It works and I thank you many times. I didn't know about the ?. I have an abstract sql class that actually is performing the query so I had to change the way I did things just a bit but the bottom line is, it works!
Thanks again,
Larry
>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>
Previous
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