Icon View Incident Report

Serious Serious
Reported By: Steve Harper
Reported On: 8/19/2002
For: Version 3.13 Build 1
# 1178 Using RepairTable Method Keeps Resetting the Last AutoInc Value to a High Figure

After finding a datafile where the last few records had AutoInc values in the millions - there are only 83 records in the file. I corrected the records, then reset the AutoInc value from the Restructure menu.

However, if I perform a Validate on the table, it reports that the AutoInc value is invalid, and a repair of the same file results in resetting the AutoInc value back to the large number, even though the data records highest AutoInc number shows the corrected value (in this case 83).

Comments Comments and Workarounds
The RepairTable functionality in the engine was calculating the high autoinc value from deleted records, which were also corrupted. It now ignores deleted records for this calculation.

Resolution Resolution
Fixed Problem on 8/19/2002 in version 3.14 build 1