Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo not populated after 2 tables joined
Message
 
 
To
19/08/2008 16:41:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01340156
Message ID:
01340158
Views:
8
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
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform