Difference between revisions of "SET FILTER"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
==Class== | ==Class== | ||
Table Organization | Table Organization | ||
Line 12: | Line 9: | ||
==Syntax== | ==Syntax== | ||
SET FILTER TO [<condition>] | SET FILTER TO [<condition>] | ||
+ | |||
SET FILTER ON | OFF | (<expL>) | SET FILTER ON | OFF | (<expL>) | ||
==See Also== | ==See Also== | ||
− | [[ | + | [[FILTER()]], [[SET RELATION]], [[SET VIEW]] |
Line 24: | Line 22: | ||
==Example== | ==Example== | ||
− | < | + | <code lang="recital"> |
use patrons | use patrons | ||
set filter to event = "BALLET" and date < date() | set filter to event = "BALLET" and date < date() | ||
− | browse</ | + | browse</code> |
Revision as of 09:12, 16 April 2009
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
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 Database Server, Recital Mirage Server, Recital Terminal Developer