General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
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.
>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only