Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL GROUP BY with MEMO-Field in Fieldlist
Message
De
15/11/2013 12:58:34
 
 
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:
01588061
Vues:
37
Thank you very much,

I will add a primary key and be happy!

Gerhard

>>Me again ;-)
>>
>>Because you asked if a primary key exists: Is there solution whit a primary key without the need to cut the memofield?
>>
>>Gerhard
>>
>Yes.
>
>select T.* from Tab1 T inner join (select Field1, Field2, min(PK) as MinPK from Tab1 GROUP BY Field1, Field2) X 
>ON Tab1.PK = X.MinPK
Gerhard Schmidbauer
URANUS Software GmbH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform