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.

>This doesn't make much sense. Try to add an extra field to your select statement with first, say, 50 characters of the Memo and check it.
>
>>This seems like something simple I have done many times before, so I must be missing something.
>>In the code below the cursor curobjects has a memo field called m_full_containership
>>each row in curobjects has data in m_full_containership. Upon inspecting m_full_containership in
>>curobjectsproperties2, M_full_containership is empty in every row.
>>
>>Any help appreciated!
>>
>>
>>

>>SELECT curobjects.*, CUROBJECTSPROPERTIES.C_PROPERTY_NAME, curobjectsproperties.cvalue, curobjectsproperties.cvaluetype FROM ;
>>curobjects, curobjectsproperties WHERE curobjects.n_id = curobjectsproperties.n_id ;
>>INTO cursor curobjectsproperties2 readwrite
>>INDEX ON n_id TAG xn_id
>>*BROWSE nomod