Click or drag to resize

FCount Function

X#
Return the number of fields in the current database file.

Namespace:  XSharp.RT
Assembly:  XSharp.RT (in XSharp.RT.dll) Version: 2.19
Syntax
 FUNCTION FCount() AS DWORD
Request Example View Source

Return Value

Type: DWord
If there is no database file open, FCount() returns 0.
Remarks
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.
By default, this function operates on the currently selected work area.
It can be made to operate on an unselected work area by specifying it within an aliased expression or by calling the overload that accepts a workarea parameter (a workarea number or alias ).
Examples
This example uses FCount() to return the number of fields in the current and an unselected work area:
X#
1USE Sales NEW
2USE Customer NEW
3? FCount()                    // Result: 5
4? Sales ->(FCount())            // Result: 8
This example uses FCount() to declare an array with field information:
X#
1LOCAL aFields := ARRAY(FCount())
2AFields(aFields)
This example uses FCount() as the upper boundary of a FOR loop that processes the list of current work area fields:
X#
1LOCAL nField
2USE Sales NEW
3FOR nField := 1 UPTO FCount()
4    ? FIELDNAME(nField)
5NEXT
See Also