Returns the table filter expression specified in SET FILTER.
Syntax
FILTER([nWorkArea | cTableAlias])
Returns
Character
Arguments
nWorkArea
Specifies the work area of the table for which FILTER( ) returns the filter expression.
FILTER( ) returns the empty string if a table isn't open in the work area you specify.
cTableAlias
Specifies the alias of the table for which FILTER( ) returns the filter expression.
Visual FoxPro generates an error message if you specify a table alias that doesn't exist.
Remarks
If you omit the optional arguments, FILTER( ) returns the filter expression for the table open in the currently selected work area. For more information about creating a filter, see SET FILTER.