Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL GROUP BY with MEMO-Field in Fieldlist
Message
 
 
À
15/11/2013 12:17:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01587998
Message ID:
01588046
Vues:
35
>No, the table does not have a primary key. The Memos whithin a group are also equal to the last character.
>
>The table could have this values:
>
>F1, F2, F3, F4, F5 (memo)
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>
>What I need is a table like that:
>Walter Meier, Hallo Walter, 20120101, 20121231, complete adress with multible lines for Walter Meier
>Gesine Huber, Liebe Gesine, 20120101, 20121231, complete adress with multible lines for Gesine Huber
>
>TIA
>Gerhard
>
>
If the information in the memo is less than 254 characters, then you can use these 254 chars and use distinct. Otherwise there is no way without a primary key.
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