ROWCOUNT

Summary


rowcount is used to identify the number of records for all or part of a table.

Syntax

   rowcount( class )

Parameters

Element

Description

Restrictions

class

Description of a table.

The table must be opened.

Examples

   # How many active customers ?
    Local File BPCUSTOMER [BPC] where BPCSTA = 2
    Infbox "Number of active customers:"-num$(rowcount([BPC]))
   # How many customers in total ?
    Local File BPCUSTOMER [BPC] 
    Infbox "Number of customers:"-num$(rowcount([BPC]))
   # this result can also be obtained by :
    Local File BPCUSTOMER [BPC] 
    Infbox "Number of customers :"-num$(Nbrecord ([BPC]))

Description and comments

rowcount gives the number of records in part or all of a table that is already open (by File or Trbegin).

 rowcount takes into account the filters applied to the table. 

rowcount can be applied to a link.

rowcount returns the number of records the same as nbrecord; in addition, it is used to take into account the filters applied to the table,  to return the number of records in a link.

Associated errors

Error

Description

ERCLAS (7)

The file is not open.

Associated keywords

FILE - TRBEGIN - NBRECORD


SUMMARY


Copyright © Sage 1999 - 2007