LAST SUBRECORD

version 11 (Modified)

LAST SUBRECORD (subtable)

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.

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

FIRST SUBRECORD, NEXT SUBRECORD, PREVIOUS SUBRECORD.