SET FILTER

From Recital Documentation Wiki
Revision as of 16:05, 10 March 2009 by Yvonnemilne (Talk | contribs)

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

SET FILTER

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