OPTIONSTRING Function (FieldRef)

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

OptionString := FieldRef.OPTIONSTRING

Parameters

  • FieldRef
    Type: FieldRef Refers to the current field.

Property Value/Return Value

Type: Text

The list of options that is available in the field.

Remarks

All the options for this field are returned as a comma separated string.

This function 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 RecordRef variable that is named ItemRecref and creates a reference to field 19 (Price/Profit Calculation), which is an Options field. The OPTIONSTRING function retrieves the options in the field and displays them as a comma separated list. This example requires that you create the following variables in the C/AL Globals windows.

Variable name DataType

ItemRecref

RecordRef

MyFieldRef

FieldRef

OptionString

Text

ItemRecref.OPEN(DATABASE::Item);
MyFieldRef := ItemRecref.FIELD(19);
OptionString := MyFieldRef.OPTIONSTRING;
MESSAGE(' %1', OptionString);

See Also

Reference

FieldRef Data Type