version 11 (Modified)
ALL SUBRECORDS (subtable)
Parameter | Type | Description | |
subtable | Subtable | Subtable in which to select all subrecords |
Compatibility note: Subtables are no longer supported starting with version 11 of 4D. A compatibility mechanism ensures the functioning of this command in converted databases; however, it is strongly recommended to replace any subtables with standard related tables.
Description
ALL SUBRECORDS makes all the subrecords of subtable the current subselection. If a current parent record does not exist, ALL SUBRECORDS has no effect. When a parent record is first loaded, the subselection contains all subrecords. A subselection may not contain all subrecords after ADD SUBRECORD, QUERY SUBRECORDS, or DELETE SUBRECORD is executed.
Example
The following example selects all subrecords to ensure that they are all included in the sum:
ALL SUBRECORDS ([Stats]Sales) TotalSales := Sum ([Stats]Sales'Dollars)
See Also
QUERY SUBRECORDS, Records in subselection.