Difference between revisions of "RECCOUNT()"

From Lianjapedia
Jump to: navigation, search
m (1 revision)
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[RECSIZE()]], [[DBF()]], [[NDX()]], [[HEADER()]], [[FCOUNT()]], [[INDEXKEY()]]
+
[[RECSIZE()]], [[DBF()]], [[NDX()]], [[FCOUNT()]], [[INDEXKEY()]], [[ROWCOUNT()]]
  
  
Line 26: Line 26:
 
</code>
 
</code>
  
 
==Products==
 
Recital, Recital Server
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Revision as of 07:23, 7 February 2012

Purpose

Function to return the number of records in table


Syntax

RECCOUNT([<workarea | alias>])


See Also

RECSIZE(), DBF(), NDX(), FCOUNT(), INDEXKEY(), ROWCOUNT()


Description

The RECCOUNT() function returns a number representing the total number of records in the currently selected table. This number includes records that have been marked for deletion. If the optional <workarea | alias> is specified, then the function will operate in the required location.


Example

use accounts
? reccount()
      2500
? fcount()
        18
declare aAccounts[reccount(),fcount()]
copy to array aAccounts for empty(paid_date)