其实如果你找找以前的问题中是有这类问题的答案的
你的问题可以归述为:查找数据表的某一字段重复记录的问题,建议你用sql查询
这也是sql的精华之一。老多教材拿来做例子。
**********
select * from yourstable where name in (select name from yourstable group by name having count(*)>1)
ELECT CLERK_NAME,CNT(*) FROM a ;
INTO CURSOR C GROUP BY CLERK_NAME
SELECT ID,CLERK_NAME FROM A ;
WHERE CLERK_NAME IN (SELECT CLERK_NAME FROM C WHERE CNT > 1);
INTO TABLE b
如果只是要筛去重复的记录,可用:
SELECT DISTINCT name FROM myTable ......
如果想把有重复记录的记录筛选出来,可用
SELECT name, COUNT(*) AS rec FROM myTable GROUP BY name Having rec>1 ...
总之,得根据具体的任务来决定。
use a in 1
use b in 2
sele a
scan all
sele b
locate for b.clerk_name=a.clerk_name
if not(found())
insert into b(id,clerk_name) values (a.id,a.clerk_name)
endif
endscan