Records in selection

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 3


Records in selection {(aTable)} Number

ParameterTypeDescription
aTableTableTable for which to return number of selected records,
or Default table, if omitted
Function resultNumberRecords in selection of table

Description

Records in selection returns the number of records in the current selection of aTable. In contrast, Records in table returns the total number of records in the table.

Example

The following example shows a loop technique commonly used to move through all the records in a selection. The same action can also be accomplished with the APPLY TO SELECTION command:

   FIRST RECORD ([People])   ` Start at first record in the selection 
   For ($vlRecord; 1; Records in selection ([People]))   ` Loop once for each record 
      Do Something   ` Do something with the record 
      NEXT RECORD ([People])   ` Move to the next record 
   End for

See Also

Records in table.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next