Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
This Select Group claims to be Missing or Invalid
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01252346
Message ID:
01252414
Views:
31
>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...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform