ROWCOUNT |
rowcount is used to identify the number of records for all or part of a table.
rowcount( class )
|
Element |
Description |
Restrictions |
|
class |
Description of a table. |
The table must be opened. |
# How many active customers ? Local File BPCUSTOMER [BPC] where BPCSTA = 2Infbox "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]))
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.
|
Error |
Description |
|
ERCLAS (7) |
The file is not open. |
|
|