xHarbour Reference Documentation > Function Reference

DbClearFilter()

Clears the current filter condition in a work area.

Syntax

DbClearFilter() --> NIL

Return

The return value is always NIL.

Description

The function clears an active filter condition in the current work area. As a result, all records previously filtered become visible again in database navigation.

Use an aliased expression to clear a filter in a different work area.

Info

See also:	DbFilter(), DbSetFilter(), SET DELETED, SET FILTER, SET SCOPE
Category:	Database functions
Source:	rdd\dbcmd.c
LIB:	xhb.lib
DLL:	xhbdll.dll

Example

// The example demonstrates visibility of filtered records

   PROCEDURE Main

      USE Customer ALIAS Cust SHARED
      INDEX ON Upper(Lastname+Firstname) TO Cust01

      GO TOP
      ? Cust->Lastname                 // result: Alberts

      SET FILTER TO Cust->Lastname > "E"

      GO TOP
      ? Cust->Lastname                 // result: Feldman

      Cust->(DbClearFilter())

      GO TOP
      ? Cust->Lastname                 // result: Alberts

      CLOSE Cust
   RETURN