-100错解决问题？？

一把火

-100    ISAM error: duplicate value for a record with unique key.

A row that was to be inserted or updated has a key value that already
exists in its index. For C-ISAM programs, a duplicate value was
presented in the last call to iswrite, isrewrite, isrewcurr, or
isaddindex. Review the program logic and the input data. For SQL
products, a duplicate key value was used in the last INSERT or UPDATE.
唯一索引上有重复值了 ，请问出现后的解决方法是什么，请高手指点一下，谢谢？
我单位的数据库中在做销售中时常出现，苦等中……

lmtok

看看表上有什么唯一索引，是不是有新插入的数据或者是update的数据违反了这个唯一索引的约束

yu_xiao_64

select colname,count(*) from tabname group by 1 having count(*)>1  其中colname是带唯一索引的列，找到之后删除多余的一行，使得这个列上没有重复值

zhan_yl

1、修改应用使重复值的记录不要insert或update出来
2、修改索引允许重复值或扩大唯一值的范围