Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo not populated after 2 tables joined
Message
 
 
À
19/08/2008 16:41:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2008 Server
Database:
Visual FoxPro
Divers
Thread ID:
01340156
Message ID:
01340158
Vues:
9
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform