FCount Function |
Return the number of fields in the current database file.
Namespace: XSharp.RT
Assembly: XSharp.RT (in XSharp.RT.dll) Version: 2.7
SyntaxRequest Example
View Source
If there is no database file open, FCount() returns 0.
Return Value
Type: UInt32If 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.
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:
This example uses FCount() to declare an array with field information:
This example uses FCount() as the upper boundary of a FOR loop that processes the list of current work area fields:
X#
1USE Sales NEW 2USE Customer NEW 3? FCount() // Result: 5 4? Sales ->(FCount()) // Result: 8
X#
1LOCAL aFields := ARRAY(FCount()) 2AFields(aFields)
X#
1LOCAL nField 2USE Sales NEW 3FOR nField := 1 UPTO FCount() 4 ? FIELDNAME(nField) 5NEXT
See Also