Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo not populated after 2 tables joined
Message
From
19/08/2008 16:41:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Memo not populated after 2 tables joined
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01340156
Message ID:
01340156
Views:
52
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
Next
Reply
Map
View

Click here to load this message in the networking platform