Reported By: Neil Anderson Reported On: 1/22/2004 For: Version 4.02 Build 1
# 1552Record 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.
CommentsThe 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.
ResolutionFixed Problem on 1/23/2004 in version 4.03 build 1