FIELDNO Function (Record)
Gets the number assigned to a field in the table description.
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.
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.