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 13:50:02
 
 
À
15/11/2013 13:05:40
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:
01588074
Vues:
42
>"very likely to be unique" always worries me. My experience is you eventually get in trouble.
>

True. And on an afterthought - I don't see why we cannot use a pk - valid for the lifetime of the query - using a derived table
	select * ;
		from ( select recno() as pk, ;
				Test.* ;
				from Test ;
			) X
>>You can make a sort of PK - two fields together
>>
>>PartOne + PartTwo is an expression that is very likely to be unique
>>
>>
>>	select cast(sys(2007, F5, 0, 1) as B(0)) as PartOne, ;
>>			padr(F5, 200) as PartTwo, ;
>>			count(*) ;
>>		from test ;
>>		group by 1, 2
>>
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform