>>>>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.
>
>Try to replace the ampersand with some other character, and do a similar replacement afterwards to put it back again. A pair of chrtran() will do the job.