>>>>Hi all,
>>>>
>>>>Is there a (sql) command that can calculate the number of unique records of a field into a table with just one command in VFP 5?
>>>>
>>>>Thanks beforehand.
>>>
>>>How about
>>>
>>>
SELECT COUNT (DISTINCT yourfield) FROM yourTable INTO ARRAY aTemp
>>
>>Are you sure this would work in VFP5?
>
>Pretty sure. Actually, I
think this syntax is valid as far back as 2.6 but can't validate that from where I am now.
I keep a copy of FPD2.6 around for checking out things like this, but it flatly refused to allow Distinct anywhere - actually it doesn't do any selects, no matter what I do. Maybe it's just rotten :).