Click or drag to resize

FCount Function

Return the number of fields in the current database file.

Namespace:  XSharp.RT
Assembly:  XSharp.RT (in XSharp.RT.dll) Version: 2.3a
Syntax
Copy
 FUNCTION FCount() AS DWORD
View Source

Return Value

Type: UInt32
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.
Examples
This example uses FCount() to return the number of fields in the current and an unselected work area:
X#
Copy
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#
Copy
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#
Copy
1LOCAL nField
2USE Sales NEW
3FOR nField := 1 UPTO FCount()
4    ? FIELDNAME(nField)
5NEXT
See Also