Return the number of fields in the current database file.
XSharp.RT (in XSharp.RT.dll) Version: 2.3
Syntax View Source
uArea AS USUAL
) AS DWORD
public static uint FCount(
- Type: Usual
Specifies the work area name or number for a table from which the value must be retrieved.
If there is no database file open, FCount() returns 0.
FCount() is useful in applications containing data-independent programs that can operate on any database file. These include generalized import/export and reporting programs. Typically, you use FCount() to establish the upper limit of a FOR...NEXT or DO WHILE loop that processes a single field at a time.
This example uses FCount() to return the number of fields in the current and an unselected work area:
1USE Sales NEW
2USE Customer NEW
4? Sales ->(FCount())
This example uses FCount() to declare an array with field information:
1LOCAL aFields := ARRAY(FCount())
This example uses FCount() as the upper boundary of a FOR loop that processes the list of current work area fields:
2USE Sales NEW
3FOR nField := 1 UPTO FCount()
4 ? FIELDNAME(nField)