FIELDNO Function (Record)

• 06/05/2016
• 2 minutes to read
• Contributors
  • 
  • 
  • 
  • 

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.

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.

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.

See Also

Record Data Type