Filtering Multiple Rows Based On Update Status
Filter a recordset to show only those rows that belong to a group of rows with the same update status using the FilterGroup property. Set FilterGroup to the TFilterGroup constant that represents the update status of rows to display. A value of fgNone (the default value for this property) specifies that no filtering is applied and all rows are visible regardless of update status (except rows marked for deletion). The example below causes only pending batch update rows to be visible.
FilterGroup := fgPendingRecords; Filtered := True;
FilterGroup = fgPendingRecords; Filtered = true;
Note: For the FilterGroup property to have an effect, the ADO dataset component's Filtered property must be set to True.