RECORD Function (FieldRef)

Gets the RecordRef of the field that is currently selected.

This function returns an error if no field is selected.

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

Reference

FieldRef Data Type