Difference between revisions of "FCOUNT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
==Class==
 
Fields and Records
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to count fields contained in a table
 
Function to count fields contained in a table
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[AFIELDS()]], [[DBF()]], [[DISPLAY STRUCTURE]], [[FIELD()]], [[FILTER()]], [[FMT()]], [[NFCOUNT()]], [[NDX()]], [[SET FIELDS]]
+
[[AFIELDS()]], [[DBF()]], [[DISPLAY STRUCTURE]], [[FIELD()]], [[FILTER()]], [[FMT()]], [[LABEL()]], [[NFCOUNT()]], [[NDX()]], [[SET FIELDS]]
  
  
Line 30: Line 26:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 15:11, 25 August 2011

Purpose

Function to count fields contained in a table


Syntax

FCOUNT([<workarea | alias>])


See Also

AFIELDS(), DBF(), DISPLAY STRUCTURE, FIELD(), FILTER(), FMT(), 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


Products

Recital Server, Recital