Class
Table Organization

Purpose
Seclude records in a table that do not satisfy a certain condition

Syntax
SET FILTER TO [<condition>]
SET FILTER ON | OFF | (<expL>)

See Also
SET RELATION, SET VIEW, FILTER()

Description
If SET FILTER TO <condition> is specified, records that do not satisfy the specified <condition> are automatically secluded.  If SET FILTER TO is specified, without a <condition>, the current filter is removed allowing all records to be accessed.  The filter <condition> is specific to each workarea, and is removed when a table is closed, or the workarea is re-used.  However, the FILTER condition can contain references to fields in related tables.  The FILTER() function can be used to save the current filter <condition>.  The SET FILTER command enables or disables the filtering process.  By default, FILTER is ON.

Example
use patrons
set filter to event = “BALLET” and date < date()
browse

Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer