Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a Primary key.
Message
From
26/01/2000 08:23:31
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00322044
Message ID:
00322730
Views:
17
>Erik,
>
>Thank your for the response to the question. I'm sure it will help me. However, there's a little problem. When I run the funtion, an error pops up saying "Cannot Group By Aggregate field."
>

Woops. That should read GROUP BY 2. You are grouping on the "field" created by the concatenation of these fields.

>Also I do not understand the Sytax of the command "COUNT(*)" and I am unable to find that funtion in the Foxpro Online Help CD.
>Can you tell me what that command is doing?

COUNT() just counts the records in the group. COUNT(Field1) would do the same thing, but COUNT(*) just tells the reader that you don't care which field is being counted.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform