Icon View Incident Report

Serious Serious
Reported By: Johnnie Norsworthy
Reported On: 1/9/2004
For: Version 4.01 Build 1
# 1529 RepairTable 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 Comments and Workarounds
The RepairTable method now fixes this problem, as does the REPAIR TABLE SQL statement.

Resolution Resolution
Fixed Problem on 1/11/2004 in version 4.02 build 1