Click above to get retro games delivered to your door ever month!

SET FILTER


Syntax:     SET FILTER TO [<condition>]

Purpose:    To make a database file appear as if it contains only the
            records meeting a specified condition.

Argument:   <condition> is a logical expression that identifies a
            specific set of records.

            To deactivate the filter condition, enter SET FILTER TO
            without a <condition>.

Usage:      When a FILTER condition is SET, the database file acts as if
            it contains only the records matching the specified
            condition.  Each work area can have an active filter.  Once
            a FILTER is SET, it is not activated until the record
            pointer is moved from its current position.  Generally, use
            GO TOP to activate it.

            As with SET DELETED, a filter has no effect on INDEX and
            REINDEX.  You may also directly access filtered records with
            GOTO or commands using the RECORD scope.

Library:    CLIPPER.LIB


----------------------------------- Examples -------------------------------

   USE Customers
   SET FILTER TO Zipcode > "50000"
   GO TOP

   LIST Lastname, Zipcode

   SET FILTER TO