4D v13.4
LAST SUBRECORD
LAST SUBRECORD
| LAST SUBRECORD ( subtable ) | ||||||||
| Parameter | Type | Description | ||||||
| subtable | Subtable |
|
Subtable in which to move to the last selected subrecord | |||||
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.
LAST SUBRECORD makes the last subrecord of the current subselection of subtable the current subrecord. If the current subselection is empty, LAST SUBRECORD has no effect.
The following example concatenates the first and last names in child records stored in a subtable. It copies the names into an array, called atNames. It is the same as the example for FIRST SUBRECORD except that it moves through the subrecords from last to first:
` Create an array to hold the names
ARRAY TEXT(atNames;Records in subselection([People]Children))
LAST SUBRECORD([People]Children) ` Start at the last subrecord and loop once for each child
For($vlSub;1;Records in subselection([People]Children))
atNames{$vlSub}:=[People]Children First Names+" "+[People]Children Last Names
PREVIOUS SUBRECORD([People]Children)
End for
Product: 4D
Theme: Subrecords
Number:
201
Modified: 4D v11 SQL
FIRST SUBRECORD
NEXT SUBRECORD
PREVIOUS SUBRECORD
