>>If I run the following example in VFP command window, all works well. But if I run this code in a VFP stored procedure called via Ole Db provider, the value that goes into the field is blank/empty:
>>
>>
>>
>>create table ("MyTest") free ( test_str c(200) )
>>
>>cTestStr = "Test & test"
>>APPEND BLANK IN mytest
>>replace test_str WITH cTestStr IN mytest
>>
>>*-- The value that goes to field TEST_STR is blank when
>>*-- calling this code via Ole Db Provider.
>>
>>
>>What am I missing?
>Try
>cTestStr = "Test " + chr(38) + " test"
I will try it. But the point is that the value [& + amp + ";"] (which by the way UT shows here as "&") inserted into the string outside my control.
Thank you.
"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