Filtering Multiple Rows Based On Update Status

Go Up to Connecting an ADO Dataset to a Data Store

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.

See Also

• Opening the Dataset in Batch Update Mode
• Inspecting the Update Status of Individual Rows
• Applying the Batch Updates to Base Tables
• Canceling Batch Updates