4D v13.4
Before subselection
Before subselection
| Before subselection ( subtable ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| subtable | Subtable |
|
Subtable for which to test if subrecord pointer is before the first selected subrecord | |||||
| Function result | Boolean |
|
Yes (TRUE) or No (FALSE) | |||||
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.
Before subselection returns True when the current subrecord pointer is before the first subrecord of subtable. Before subselection is used to check whether or not PREVIOUS SUBRECORD has moved the pointer before the first subrecord. If the current subselection is empty, Before subselection returns True.
The following example is an object method for a button. When the button is clicked, the pointer moves to the previous subrecord. If the pointer is before the first subrecord, it moves to the last subrecord:
PREVIOUS SUBRECORD([People]Children) ` Move to the previous subrecord
If(Before subselection([People]Children) ` If we have gone too far...
LAST SUBRECORD([People]Children) ` move to the last subrecord
End if
Product: 4D
Theme: Subrecords
Number:
199
Modified: 4D v11 SQL
