property FilterRecordCounts: Boolean

Usage

Use the FilterRecordCounts property to specify how record counts are returned for filtered datasets and live query result sets. The default value of this property is True, which means the RecordCount property of the TDBISAMTable and TDBISAMQuery components will always take into account any active filters (or WHERE clauses with live query result sets) when showing the record count of the dataset. If the FilterRecordCounts property is set to False, the RecordCount property of the TDBISAMTable and TDBISAMQuery components will always show the total record count of the entire dataset or active range (if a range is set) only and will not take any active filters (or WHERE clauses with live query result sets) into account. To get the record count including any active filters, use the FilterRecordCount property of the TDBISAMTable and TDBISAMQuery components. This property always shows the accurate record count, regardless of the current setting of the TDBISAMEngine FilterRecordCounts property.

Setting the TDBISAMEngine FilterRecordCounts property to False may be desirable for some applications since it allows for more accurate positioning of the scroll bar in a TDBGrid or similar multi-row, data-aware components.