>Is it possible to find only duplicate records using Stonefeild Query?
This can be done with a standard Visual FoxPro query; since I don't know Stonefield, you see whether you can adapt it.
In this example, KeyField should be unique, but you you suspect that it may, in fact, contain duplicates:
select KeyField, count(*) as HowMany;
from MyTable;
group by KeyField;
having HowMany > 1
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)
