Edit

Share via

FieldRef.OptionMembers() Method

  • Article

Version: Available or changed with runtime version 1.0.

Gets the list of options that are available in the field that is currently selected.

Syntax

OptionMembers :=   FieldRef.OptionMembers()

Note

This method can be invoked using property access syntax.

Parameters

FieldRef
 Type: FieldRef
An instance of the FieldRef data type.

Return Value

OptionMembers
 Type: Text

Remarks

All the options for this field are returned as a comma-separated string. This method returns an error if no field is selected.
If the field is not an option an empty string is returned.

Example

The following example opens the Item table with a RecordRef variable named ItemRecref and it then creates a reference to field 19 (Price/Profit Calculation), which is an Options field. The OptionMembers method retrieves the options in the field and displays them as a comma-separated list.

codeunit 50112 RetrieveOptions
{
    trigger OnRun()
    var
        MyFieldRef: FieldRef;
        ItemRecref: RecordRef;
        OptionMembers: Text;
    begin
        ItemRecref.Open(Database::Item);
        MyFieldRef := ItemRecref.Field(19);
        OptionMembers := MyFieldRef.OptionMembers;
        Message(' %1', OptionMembers);
    end;
}

FieldRef Data Type
Get Started with AL
Developing Extensions