>>Try

>>SELECT cCode, cDesc, dDate ;
>>	FROM mytable mt1 ;
>>	WHERE NOT EXISTS ( ;
>>		SELECT * FROM mytable mt2 ;
>>				WHERE mt2.cCode = mt1.cCode AND mt2.dDate > mt1.dDate) ;
>>	INTO CURSOR crsResult
>>
>>* or
>>
>>SELECT cCode, cDesc, dDate ;
>>	FROM mytable mt1 ;
>>	WHERE dDate = ( SELECT MAX(dDate) FROM mytable mt2 ;
>>					WHERE mt2.cCode = mt1.cCode) ;
>>	INTO CURSOR crsResult
>>

>>>
>
>I've found that, for large tables, it may be significantly faster to split this into two queries.
>

SELECT cCode,MAX(dDate) as max_date FROM myTable ;
>   GROUP BY cCode;
>   INTO CURSOR curMaxDate
>
>SELECT mt.cCode,mt.cDesc,mt.dDate;
>  FROM myTable mt ;
>  JOIN curMaxDate md ON   mt.cCode = md.cCode ;
>    AND mt.dDate = md.max_date
>

>

It could be faster, slower or the same. Only tests on real data can tell.