Jaa


FIELDINDEX Function (RecordRef)

Gets the FieldRef of the field that has the specified index in the table that is referred to by the RecordRef.

Syntax

  
Field := RecordRef.FIELDINDEX(Index)  

Parameters

RecordRef
Type: RecordRef

Index
Type: Integer

Property Value/Return Value

Type: FieldRef

The FieldRef of the field that has the specified index.

Remarks

The fields in the primary key are always listed first in the index. Therefore, the order of the fields in the index is not necessarily the same as the order of the fields in the table.

If the index is out of the range supplied or if no table is selected, then the function returns an error.

Example

This example requires that you create the following variables and text constants in the C/AL Globals window.

Variable name DataType Length
SalesInvHdr RecordRef Not applicable
FldRef FieldRef Not applicable
Str Text 1024
Text constant name Constant value
Text001 Index 1: %1\
Text002 Index 2: %2\
Text003 Index 3: %2
  
SalesInvHdr.OPEN(112);  
FldRef1 := SalesInvHdr.FIELDINDEX(1);  
FldRef2 := SalesInvHdr.FIELDINDEX(2);  
FldRef3 := SalesInvHdr.FIELDINDEX(3);  
MESSAGE(Text001 + Text002 + Text003, FldRef1.CAPTION, FldRef2.CAPTION, FldRef3.CAPTION);  

The message window displays the following:

  • Index 1: No.

  • Index 2: Sell-to Customer No.

  • Index 3: Bill-to Customer No.

    The following illustration shows the first fields in table 112, Sales Invoice Header, when you design the table in Object Designer, and shows the keys for table 112. The order of the fields in the index differs from the order of the fields in the table. The index lists the field in the primary key first.

    Table 112 designer and keys

See Also

RecordRef Data Type