SET FILTER

From Recital Documentation Wiki
Revision as of 15:17, 11 March 2009 by Yvonnemilne (Talk | contribs)

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