Difference between revisions of "FCOUNT()"

From Lianjapedia
Jump to: navigation, search
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Function to count fields contained in a table
 
Function to count fields contained in a table
 
  
 
==Syntax==
 
==Syntax==
 
FCOUNT([<workarea | alias>])
 
FCOUNT([<workarea | alias>])
 
  
 
==See Also==
 
==See Also==
[[AFIELDS()]], [[DBF()]], [[DISPLAY STRUCTURE]], [[FIELD()]], [[FILTER()]], [[FMT()]], [[LABEL()]], [[NFCOUNT()]], [[NDX()]], [[SET FIELDS]]
+
[[AFIELDS()]], [[DBF()]], [[DISPLAY STRUCTURE]], [[FIELD()]], [[FILTER()]], [[LABEL()]], [[NFCOUNT()]], [[NDX()]], [[SET FIELDS]]
 
+
  
 
==Description==
 
==Description==
 
The FCOUNT() function returns the number of fields in the active table.  If the optional <workarea | alias> is specified, then the function will operate in the required location.  The command SET FIELDS will affect the value returned by the FCOUNT() function.
 
The FCOUNT() function returns the number of fields in the active table.  If the optional <workarea | alias> is specified, then the function will operate in the required location.  The command SET FIELDS will affect the value returned by the FCOUNT() function.
 
  
 
==Example==
 
==Example==
Line 24: Line 20:
 
</code>
 
</code>
  
 
==Products==
 
Recital Server, Recital
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 08:28, 10 February 2012

Purpose

Function to count fields contained in a table

Syntax

FCOUNT([<workarea | alias>])

See Also

AFIELDS(), DBF(), DISPLAY STRUCTURE, FIELD(), FILTER(), LABEL(), NFCOUNT(), NDX(), SET FIELDS

Description

The FCOUNT() function returns the number of fields in the active table. If the optional <workarea | alias> is specified, then the function will operate in the required location. The command SET FIELDS will affect the value returned by the FCOUNT() function.

Example

use accounts
do while i <= fcount()
    ? field(i)
    ++ i
enddo