The Filters page is used to maintain the FilterExpressions collection. Use the FilterExpression property to access the FilterExpressions collection in code.
Filter expressions restrict the set of records retrieved to the Recordset. For each fetched record, the TData control evaluates each filter expression and excludes the record from the resulting recordset if the filter expression evaluates to False. See Filters for details.
If multiple filter expressions are defined, they work as if they were connected by a logical AND operator.
IMPORTANT: Do not forget that filter expressions are only evaluated if the Filtered property of the TData control is True. To enable filters, check the box labeled Filtered on the General property page or set the Filtered property in code.
The Filters page is initially empty. Click the New button to create an uninitialized filter and enable the other controls on the page. Alternatively, you can right-click the Filters list and choose New from the context menu.
To remove a filter from the list, select it and click the Delete button, or right-click it and choose Delete from the context menu. You can change the evaluation order of the filters by dragging individual items within the Filters list.
When you select an item in the Filters list, the other controls on the page display the attributes of the selected filter:
|
Specifies a Boolean expression that will be evaluated once per record to filter the recordset. |
|
|
Represented by the Condition edit box beside Filter Expression. Specifies an optional Boolean expression that will be evaluated once per record to determine whether the associated filter expression should be evaluated at all. If the condition expression is empty or evaluates to True, the filter expression will be evaluated; if the condition expression evaluates to False, the filter expression will not be evaluated. |
 |
Note: Neither expression will be evaluated if the Filtered property of the control is False. |