Reported By: Johnnie Norsworthy Reported On: 1/9/2004 For: Version 4.01 Build 1
# 1529RepairTable Does Not Correct Issues with Incorrect Last AutoInc Value in a Table I had a table with this error:
DBISAM Engine Error # 9729 Duplicate key found in the index 'Primary' of the table 'APT'.
Even after repairs with index building I continued to get this error when I tried to add a new record. Records could not be saved by my program or in DBSys.
The primary index is an AutoInc.
The way I finally got the file to work was to add a new record *with* a value in the primary key and then afterward delete that record. After that new records saved fine and the AutoInc primary key incremented normally.
Comments and WorkaroundsThe RepairTable method now fixes this problem, as does the REPAIR TABLE SQL statement.
ResolutionFixed Problem on 1/11/2004 in version 4.02 build 1