Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL GROUP BY with MEMO-Field in Fieldlist
Message
 
 
À
15/11/2013 13:50:02
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:
01588088
Vues:
37
>>"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
>
I know we can not use RECNO() when select uses more than 1 table. I haven't tested it with the derived table, but I think we need to have a real PK, each table should have a PK anyway.
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