4D v14.3APPLY TO SUBSELECTION |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v14.3
APPLY TO SUBSELECTION
|
APPLY TO SUBSELECTION ( subtable ; statement ) | ||||||||
Parameter | Type | Description | ||||||
subtable | Subtable |
![]() |
Subtable to which to apply the formula | |||||
statement | Statement |
![]() |
One line of code or a method | |||||
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.
APPLY TO SUBSELECTION applies statement to each subrecord in the current subselection of subtable. The statement may be a statement or a method. If the statement modifies a subrecord, the modified subrecord is written to disk only when the parent record is written. If the subselection is empty, APPLY TO SUBSELECTION has no effect.
APPLY TO SUBSELECTION can be used to gather information from the subselection or to modify the subselection.
Product: 4D
Theme: Subrecords
Number:
73
Modified: 4D v11 SQL
ALL SUBRECORDS
EDIT FORMULA
QUERY SUBRECORDS
SAVE RECORD
4D Language Reference ( 4D v12.4)
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)
Inherited from : APPLY TO SUBSELECTION ( 4D v11 SQL Release 6)