RAD Studio |  |

Filtering Multiple Rows Based On Update Status
See Also
Collapse All

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.

Copy Code

    FilterGroup := fgPendingRecords;
    Filtered := True;

Copy Code

    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

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!