FCOUNT( ) Function

Example   See Also

Returns the number of fields in a table.

Syntax

FCOUNT([nWorkArea | cTableAlias])

Returns

Numeric

Arguments

nWorkArea

Specifies the work area of the table for which FCOUNT( ) returns the number of fields.

FCOUNT( ) returns 0 if a table isn't open in the work area you specify.

cTableAlias

Specifies the alias of the table for which FCOUNT( ) returns the number of fields.

Visual FoxPro generates an error message if you specify a table alias that doesn't exist.

Remarks

If you omit the optional arguments, FCOUNT( ) returns the number of fields in the table open in the currently selected work area.