ACTIVE Function (FieldRef)

Checks whether the field that is currently selected is enabled.

Syntax

  
Ok := FieldRef.ACTIVE  

Parameters

FieldRef
Type: FieldRef

Refers to the current field.

Property Value/Return Value

Type: Boolean

true if the field is enabled; otherwise, false.

Remarks

Each field in a record can be set as enabled or disabled in the table description.

You cannot use a disabled field because disabled fields cannot contain data.

This function is like the FIELDACTIVE Function (Record) function.

Example

The following example opens table 18 (Customer) as a RecordRef variable that is named Recref. The FIELD Function (RecordRef) uses Recref to create a FieldRef variable that is named MyFieldRef. MyFieldRef sets a reference to the first field (field 1) in the table. The SETRANGE Function (FieldRef) sets a filter that selects record 30000. The FIND Function (RecordRef) selects the record and then loops through fields1 through 6. For each field, the ACTIVE function determines whether the field is enabled. If the field is enabled, a message that states that the field is enabled is displayed. Otherwise, a message that states that the field is not enabled is displayed.

Note

You can use the name of the table instead of the table number to open the table by using the following syntax: Recref.OPEN(DATABASE::Customer).

This example requires that you create the following variables and text constants in the C/AL Globals windows.

Variable name DataType
Recref RecordRef
MyFieldRef FieldRef
i Integer
Text constant ENU value
Text000 Field %1 is enabled.
Text001 Field %1 is not enabled.
  
Recref.OPEN(18);  
MyFieldRef := Recref.FIELD(1);  
MyFieldRef.SETRANGE('30000');  
Recref.FIND('-');  
FOR i := 1 TO 5 DO BEGIN  
  MyFieldRef := Recref.FIELDINDEX(i);  
  IF MyFieldRef.ACTIVE THEN  
    MESSAGE(Text000, i)  
  ELSE BEGIN  
    MESSAGE(Text001, i)  
  END;  
END;  
  

See Also

FieldRef Data Type