General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Memo not populated after 2 tables joined
Environment versions
Network:
Windows 2008 Server
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
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