>Hilmar sent me this solution for tracking duplicates in a database a little while ago - it works very well.
>Further to this solution, how would i display the names plus an added field called field2 and attribute this information to a variable called myinfo.
>
>Thanks for your help.
>k
>
>
>select name, count(*) as count;
> from mydata;
>group by name;
>having count > 1;
>INTO CURSOR TEMPDUPLICATE
>if _tally > 0
>MessageBox("Alert: There are duplicates.")
>browse normal
>endif
>If I understand correctly, you want to concatenate (combine) texts from some field from the individual members of a group of duplicates. There is no special Visual FoxPro function to do that; you would have to loop through the individual records yourself.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
