4D v13.4

FIRST SUBRECORD

Home

 
4D v13.4
FIRST SUBRECORD

FIRST SUBRECORD 


 

FIRST SUBRECORD ( subtable ) 
Parameter Type   Description
subtable  Subtable in Subtable in which to move to the first 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.

FIRST SUBRECORD makes the first subrecord of the current subselection of subtable the current subrecord. All query, selection, and order by commands also set the current subrecord to the first subrecord. If the current subselection is empty, FIRST SUBRECORD has no effect.

Example  

The following example concatenates the first and last names in child records stored in a subtable. It copies the names into the array atNames:

  ` Create an array to hold the names
 ARRAY TEXT(atNames;Records in subselection([People]Children))
 FIRST SUBRECORD([People]Children) ` Start at the first subrecord and loop once for each child
 For($vlSub;1;Records in subselection([People]Children))
    atNames{$vlSub}:=[People]Children'First Name+" "+[People]Children'Last Name
    NEXT SUBRECORD([People]Children)
 End for

 
PROPERTIES 

Product: 4D
Theme: Subrecords
Number: 61

This command is deprecated and should not be used anymore

 
INDEX

Alphabetical list of commands

 
HISTORY 

Modified: 4D v11 SQL

 
SEE ALSO 

LAST SUBRECORD
NEXT SUBRECORD
PREVIOUS SUBRECORD