Click or drag to resize

DbClearFilter Function

Clear a logical filter condition.

Namespace:  XSharp.RT
Assembly:  XSharp.RT (in XSharp.RT.dll) Version: 2.10
Syntax
 FUNCTION DbClearFilter() AS LOGIC
View Source

Return Value

Type: Boolean
TRUE if successful; otherwise, FALSE.
Remarks
DBClearFilter() performs the same function as the SET FILTER command with no expression specified.  For more information, refer to SET FILTER. By default, this function operates on the currently selected work area.   It can be made to operate on an unselected work area by specifying it within an aliased expression or by calling the overload that accepts a workarea parameter (a workarea number or alias ).
Tip Tip
Logical records:  DBClearFilter() affects the logical visibility of records in a work area.  For more information, refer to DBSetFilter() and the SET FILTER command.
Examples
The following example sets a filter, lists data as filtered, and then clears the filter:
X#
USE employee NEW
DBSetFilter({|| Age < 40}, "Age < 40")
GO TOP
LIST Employee->Name
DBClearFilter()
See Also