Share via


RECORD Function (FieldRef)

Gets the RecordRef of the field that is currently selected.

This function returns an error if no field is selected.

Syntax

  
RecordRef := FieldRef.RECORD  

Parameters

FieldRef
Type: FieldRef

Refers to the current field.

Return Value

Type: RecordRef

The RecordRef of the field that is currently selected.

See also RecordRef Data Type.

Example

The following example opens the Item table as a RecordRef variable that is named ItemRecref, creates a reference to field 1 (No.), and stores the value in the variable named MyFieldRef. The RECORD function uses the MyFieldRef variable to return the RecordRef of field 1 and stores the reference in a variable named MyRecRef. MyRecRef.NUMBER returns the table that the selected field belongs to. This example requires that you create the following variables and text constant in the C/AL Globals windows.

Variable name DataType
ItemRecref RecordRef
MyFieldRef FieldRef
MyRecRef RecordRef
Text constant ENU value
Text000 The selected field is from table %1.
  
ItemRecref.OPEN(DATABASE::Item);  
MyFieldRef := ItemRecref.FIELD(1);  
MyRecRef := MyFieldRef.RECORD;  
MESSAGE(Text000, MyRecRef.NUMBER);  

See Also

FieldRef Data Type