4D v20.1

Records in set

Home

4D Language Reference
- Sets
- - Sets
  - ADD TO SET
  - CLEAR SET
  - COPY SET
  - CREATE EMPTY SET
  - CREATE SET
  - CREATE SET FROM ARRAY
  - DIFFERENCE
  - INTERSECTION
  - Is in set
  - LOAD SET
  - Records in set
  - REMOVE FROM SET
  - SAVE SET
  - UNION
  - USE SET

Home

4D v20.1

4D Language Reference

Sets

Records in set


Records in set ( set ) -> Function result

Parameter	Type	Description
set	String	Name of the set to test
Function result	Longint	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.")