Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNT taking too long on network
Message
From
05/01/1999 10:33:07
 
 
To
05/01/1999 00:56:21
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00172498
Message ID:
00172763
Views:
30
>>Hi all,
>>TIA
>Perry,
>Sounds like a SQL counting by grouping :select Field1, Field2, Field3, cnt(*) ;
> from mytable ;
> group by 1,2,3 ;
> into array myarray && into cursor myCursor more parctical ?Cetin

Don't you need to precede the group by with the order by? Otherwise the un-ordered results will be inaccurate.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform