Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of unique records in one (sql) command?
Message
 
 
To
28/06/2007 14:47:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01236514
Message ID:
01236740
Views:
16
>>>
Select distinct yourfield from yourtable into array test
>>>?alen(test)
>>>?_tally && same result
>>
>>Unless table is empty.
>
>Right, which means use _tally.

Yes _TALLY is almost always accurate. In VFP8RTM SET NOTIFY CURSOR OFF makes _TALLY behave as if additive. The bug has been fixed in VFP8SP1.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform