Difference between revisions of "ISFILTERED()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to test if table has an active filter expression | Function to test if table has an active filter expression | ||
− | |||
==Syntax== | ==Syntax== | ||
ISFILTERED([<workarea | alias>]) | ISFILTERED([<workarea | alias>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[DBFILTER()]], [[FILTER()]], [[SET DELETED]], [[SET FILTER]] | + | [[DBFILTER()]], [[FILTER()]], [[SET DELETED]], [[SET FILTER]] |
− | + | ||
==Description== | ==Description== | ||
The ISFILTERED() function tests whether a table has an active filter expression. If the optional <workarea | alias> is specified, then the function will operate on the specified <workarea | alias>. ISFILTERED() returns .T. (True) if a filter is active in the current or specified table and .F. if there is no active filter or no active table in the current or specified workarea. | The ISFILTERED() function tests whether a table has an active filter expression. If the optional <workarea | alias> is specified, then the function will operate on the specified <workarea | alias>. ISFILTERED() returns .T. (True) if a filter is active in the current or specified table and .F. if there is no active filter or no active table in the current or specified workarea. | ||
− | |||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] |
Revision as of 08:17, 10 February 2012
Contents
Purpose
Function to test if table has an active filter expression
Syntax
ISFILTERED([<workarea | alias>])
See Also
DBFILTER(), FILTER(), SET DELETED, SET FILTER
Description
The ISFILTERED() function tests whether a table has an active filter expression. If the optional <workarea | alias> is specified, then the function will operate on the specified <workarea | alias>. ISFILTERED() returns .T. (True) if a filter is active in the current or specified table and .F. if there is no active filter or no active table in the current or specified workarea.
Example
use patrons set filter to event="BALLET" ? isfiltered() .T.