DBSETFILTER()

Establishes a filter condition for a work area.

Syntax

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

Arguments

<bCondition> Code block expression for filtered evaluation.

<cCondition> Optional character expression of code block.

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

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

Compliance

Clipper

Files

Library is rdd

Seealso

DBFILTER(), DBCLEARFILTER()