LAST SUBRECORD

version 3

LAST SUBRECORD (subtable)

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.