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.
Neil Lewis
IT R&D Manager
Velmore Ltd