Records in set

Records in set ( set ) : Integer

Parameter	Type		Description
set	Text	→	Name of the set to test
Function result	Integer	←	Number of records in set

Description

Records in set returns the number of records in set. If set does not exist, or if there are no records in set, the command returns 0.

Example

The following example displays an alert telling what percentage of the customers are rated as the best:

  // First calculate the percentage
 $Percent :=(Records in set("Best")/Records in table([Customers]))*100
  // Display an alert with the percentage
 ALERT(String($Percent;"##0%")+" of our customers are the best.")

See also

Records in selection
Records in table

Properties

Command number	195
Thread safe	✓