# DBSETFILTER()

Establishes a filter condition for a work area.

Syntax

  DBSETFILTER(<bCondition>, [<cCondition>]) --> NIL

Arguments

  <bCondition> Code block expression for filtered evaluation.
  <cCondition> Optional character expression of code block.

Returns

  DBSETFILTER() always returns NIL.

Description

  This function masks a database so that only those records that meet the condition prescribed by the expression in the code block <bCondition> and literally expressed as <cCondition> are visible. If <cCondition> is not passed to this function,then the DBFILTER() function will return an empty string showing no filter in that work area which in fact,would be not correct.

Examples

          FUNCTION Main()
          USE Tests NEW
          DBSETFILTER( {|| Tests->Id <100 }, "Tests->Id <100" )
          DBGOTOP()

Status

  Ready

Compliance

  This function is CA-Clipper compliant.

Files

  Library is rdd

See Also

- DBFILTER()
- DBCLEARFILTER()