FILTER( ) Function

Example   See Also

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.