SET FILTER

From Recital Documentation Wiki
Revision as of 15:50, 23 November 2009 by Helengeorge (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

FILTER(), SET RELATION, SET VIEW


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 Server, Recital