Fastest quickest way is to index on the field, set index to the index name
and browse
If you were close to harper tx I could show you how
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond Lloyd
Sent: Tuesday, December 10, 2013 2:20 PM
To: ProFox Email
select part_number, cnt(part_number) as c from mytable group by
part_number order by c desc
... will show you the duplicates at the top of the resultant cursor, if
any.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Select partnumber, partname, count(partnumber) as NumTimes
from myTable
group by partnumber, partname
having count(partnumber) 1
order by count(partnumber) desc
HTH
On Tue, Dec 10, 2013 at 2:20 PM, Desmond Lloyd desmond.ll...@gmail.comwrote:
Probably a little basic, but darned if I can
I would probably use a combination of SQL and xBase, assuming you want to
eyeball this. First run a select partnum from table group by partnum having
count(partnum) 1 into a cursor. Set a relation to partnum from your cursor
into the source table and set skip. Then browse away.
--
rk
On Tue, Dec 10, 2013 at 3:20 PM, Desmond Lloyd desmond.ll...@gmail.comwrote:
Have a table approximately 3000 records, part number, description etc.
that kind of thing. Well in some cases the part number is listed multiple
times and I need to determine what records are duplicated.
SELECT
5 matches
Mail list logo
