Hi All:

I have a table where there are dupes in a particular column, FOO. I want to create a cursor that will contain only one record per FOO, so I coded:

SELECT * ;
FROM ImpHeader ;
ORDER BY FOO ;
GROUP BY FOO ;
INTO CURSOR curHeader READWRITE

VFP doesn't like the GROUP BY, but it is a pain to GROUP BY all the other fields or aggregate them. I do need the data from the other fields, so SELECT DISTINCT FOO would not help.

What is the solution?

Thanks,

Yossi