Hello Naomi,

It looks like a case of the late afternoon delirium, lol... no problem with VFP.
In the code: First I created curobjects. Then I joined curobjects with curobjectsproperties into curproperties2 **next** I populated curobjects m_full_containership field; so of course the data was empty in curproperties2!

Thanks anyway for your help!


>David,
>
>If you just do select * from curObjects into cursor newCursorName nofilter and examine this new cursor, would you have data in the memo field? If not, then I suspect that the original cursor already lost memo field data some time in the process.
>
>It could be you somehow hit internal VFP keyword, but that's a bit strange and doubtfully real.
>
>>Naomi,
>>
>>I agree. It doesn't make any sense. I added: substr(curobjects.m_full_containership,1,50) as zz
>>zz was still blank.
>>Any other tests I do with joining two tables with memo fields, the memo data is fine.
>>Also note there is a field called cvalue in curobjectsproperties that's a memo field (prefix is c - but it is memo), and that is fine.
>>
>>I thought there might be some problem with long field names in cursors? but my testing on that was also fine. I am stumped.
>>