FIELDNO Function (Record)
Gets the number assigned to a field in the table description.
Syntax
Number := Record.FIELDNO(Field)
Parameters
Record
Type: Record
The name of the record that contains the field.
Field
Type: Field
The name of the field in the record.
Property Value/Return Value
Type: Integer
The number of the field specified.
Example
This example requires that you create the following variables.
Variable name | DataType | Subtype |
---|---|---|
Num | Integer | Not applicable |
CustomerRec | Record | Customer |
Num := CustomerRec.FIELDNO("No.");
This statement assigns the number of the No. field in the CustomerRec record to the number variable.
Example
In this example, the FIELDNO function is used to determine which field that a variable, which contains a field number, points to in a record. This example requires that you create the following variables.
Variable name | DataType | Subtype |
---|---|---|
CurrentFieldNo | Integer | Not applicable |
CustomerRec | Record | Customer |
CASE CurrentFieldNo OF
Customer.FIELDNO("No."):
...
Customer.FIELDNO(Name):
...
Customer.FIELDNO(Address):
...
ELSE
...
END;
This construct allows you to take actions based on the field number contained in the CurrentFieldNo variable.