>>>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.