4D v14.3

Records in set

Home

 
4D v14.3
Records in set

Records in set 


 

Records in set ( set ) -> Function result 
Parameter Type   Description
set  String in Name of the set to test
Function result  Longint in Number of records in set

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.")

 
PROPERTIES 

Product: 4D
Theme: Sets
Number: 195

 
HISTORY 

Created: < 4D v6

 
SEE ALSO 

Records in selection
Records in table

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)