I get the error 'Invalid key length' when :

select a.ADDRESS1,a.ADDRESS2 from DONOR a group by a.ADDRESS1,a.ADDRESS2 having count(*)>1 into cursor temp

select a.ADDRESS1 as ADDRESS1 from DONOR a ,temp b where a.ADDRESS1=b.ADDRESS1 and a.ADDRESS2=b.ADDRESS2 order by a.ADDRESS1,a.ADDRESS2 into cursor result

I attemp to find out record with duplicate value of address1 and address2.
The error locate at the second select statment.
I have try
- reindex the donor table
- add 'where .t.' at the first select statement
but still get the error. Why?

Info: Address1 and Address2 are character fields of length 50.

Thanks
-Jasper