Difference between revisions of "LASTREC()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to return number of records in table
 
Function to return number of records in table
Line 30: Line 28:
  
 
==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 16:54, 2 December 2009

Purpose

Function to return number of records in table


Syntax

LASTREC([<workarea | alias>])


See Also

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


Description

The LASTREC() 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
? lastrec()
      2500
? fcount()
        18
declare aAccounts[reccount(),fcount()]
copy to array aAccounts for empty(paid_date)


Products

Recital Server, Recital