OPTIONSTRING Function (FieldRef)
Gets the list of options that are available in the field that is currently selected.
Syntax
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);