4D v13.4
ALL SUBRECORDS
ALL SUBRECORDS
| ALL SUBRECORDS ( subtable ) | ||||||||
| Parameter | Type | Description | ||||||
| subtable | Subtable |
|
Subtable in which to select all subrecords | |||||
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.
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.
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)
Product: 4D
Theme: Subrecords
Number:
109
Modified: 4D v11 SQL
QUERY SUBRECORDS
Records in subselection
