FIELDNO Function (Record)

Article
06/05/2016

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 1

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 2

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.