Gets the number of a field as a string.
No := FieldRef.NUMBER
- Type: FieldRef Refers to the current field.
Property Value/Return Value
The number of the table or of the field.
This function is like the FIELDNO Function (Record) function.
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.
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;