>I have a table named planning in which I query a set of records into a cursor. Each record has whats known as a mainkey. There can be more than one record with the same mainkey. I would like to count the number of mainkeys in the table. For example, here is my query:L
>
>

>SELECT planning.mainkey, planning.planextra1, planning.ok, planning.okdate ;
>FROM planning ;
>WHERE planning.ok<>.t. ;
>INTO CURSOR crsresult
>

>
>A typical list of record would be:
>
>MAINKEY TYPE DATE
>JT001 Trouser 19/11/04
>JT002 Skirt 20/11/04
>JT001 Trouser 21/11/04
>
>Therefore I would like to count the number of different mainkeys. In this example the result would be 2. As there is only JT001 & JT002.
>
>Any help would be greatly appreciated.

SELECT COUNT(DISTINCT mainkey) distinct_mainkey FROM planning && WHERE ! planning.ok