Gets the number of a field as a string.

No := FieldRef.NUMBER

Parameters

FieldRef

Type: FieldRef

Refers to the current field.

Property Value/Return Value

Type: Integer

The number of the table or of the field.

Remarks

This function is like the FIELDNO Function (Record) function.

Example

The following example displays the caption and the field number of the first 10 fields in the Location table. The Location table is open as a RecordRef Data Type object and the reference is stored in the LocationRecref variable. The FieldIndex variable that stores the field index is initialized to 0. The LocationRecref variable uses the FIELDINDEX Function (RecordRef) to create a FieldRef that is named MyFieldRef for the specified field index. MyFiledRef now references the field that is specified by the FieldIndex. MyFieldref is then used to display the number and caption of the field The NUMBER Function (FieldRef) function retrieves the field number. This is repeated for the first ten fields in the table. This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType

LocationRecref

RecordRef

MyFieldRef

FieldRef

FieldIndex

Integer

 Copy Code
LocationRecref.OPEN(DATABASE::Location);
FieldIndex := 0;
REPEAT
  FieldIndex  := FieldIndex + 1;
  MyFieldRef := LocationRecref.FIELDINDEX(FieldIndex);
  MESSAGE('Field Number: %1  Field Caption: %2.' , MyFieldRef.NUMBER, MyFieldRef.CAPTION);
UNTIL FieldIndex = 10;

See Also