>>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.
ah thanks - i thought their might be a function that would provide a collective overview of the files - something list "List all name for ex2s>0 to N
that would place that information into a variable.
k