Icon View Incident Report

Serious Serious
Reported By: Neil Anderson
Reported On: 1/22/2004
For: Version 4.02 Build 1
# 1552 Record Counts Greater Than Number of Records in Table When Certain Filters Applied to a Table

It would appear that if you have an Index on a field and you run a filter on that field, the RecordCount gets corrupted. My TagBoardPeople table has a secondary index on SiteID. If I run a filter of "SiteID = X", my RecordCount & FilterRecordCount are greater than my PhysicalRecordCount! If you then alter the table to delete the SiteID index and run the program again the counts return correctly.

Comments Comments
The problem was caused by DBISAM accidentally including deleted records in the counts when certain filters that could use an index and satisfied a large portion of the entire records in the table were applied.

Resolution Resolution
Fixed Problem on 1/23/2004 in version 4.03 build 1