Icon View Incident Report

Serious Serious
Reported By: Rick Hillier
Reported On: 5/31/2004
For: Version 4.07 Build 1
# 1708 Editing and Posting a Record with an Active Filter Can Cause Invalid Records to Appear

I have a table that is filtered via an OnFilterRecord event. If the filter results in one record in the table passing the criteria, problems occur.

If, for example, I edit that single record and immediately save it, I get a duplicate record showing in the DBGrid. There is no duplicate record created in the table, however, and both entries in the grid appear to point to the same record (i.e. edits made to one record will show up in the other).

If I click the edit button (I have a DBNavigator on the form) and click the save button again, more duplicate records show up.

I can also simply click on the scroll bar to move up and down in the resulting list and more records will appear.

Sometimes, navigation will cause duplicate records to disappear as well.

Comments Comments and Workarounds
The workaround was to set the Engine.TableFilterIndexThreshhold property to 0.

Resolution Resolution
Fixed Problem on 5/31/2004 in version 4.08 build 1