Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
This Select Group claims to be Missing or Invalid
Message
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 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01252346
Message ID:
01252414
Vues:
30
>You can do a select on a memo field, but you can't use it in a 'group by' clause.

The VFP9 help says:
The GROUP BY clause specifies one or more columns used to
 group rows returned by the query. Columns referenced in the
 SQL SELECT statement list, except for aggregate expressions,
 must be included in the GROUP BY clause. You cannot group by
 Memo, General, or Blob fields.
So, I may SELECT any field, but if I am GROUPing BY, my SELECT field list may not include Memo fields? I think the help obfuscated that fact.

Thanks for your time.
Randy Bosma
VFP - Because life is too short to code in something else...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform