>>I have a routine that stores control values to elements of an array. Array is passed to a class that creates UPDATE or INSERT statement and adds/updates records in VFP table.
>>
>>The problem is when one of the controls is editbox and user types [Enter] key. The value of the editbox than probably has CHR(13) and the UPDATE statement gives error:
>>
>>
>>Command contains unrecognized phrase/keyword.
>>
>>
>>What do you suggest to do in these cases? Or am I missing something?
>>
>>Thank you.
>
>Can you strip out the offending characters???
>
CHRTRAN(editbox.value,CHR(13)+CHR(10),"")
>
>(I'm still basically a FPW2.6 dinosaur so I may have the wrong property for the control. But I think the basic idea should still work)
I thought about it too, stripping the "offending" characters. But this would change the value of the field, that is, all the word wrapping would be messed up.
Thank you for the suggestion.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
