NUMBER Function (FieldRef)
Gets the number of a field as an integer.
Syntax
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 |
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;