possible to get optionstring value ?

Business Central/NAV Developers Forum
1

hi, is their any way to get the optionstring of an option field ? i thought about a system-table or anything else but didn’t find anything … *** quack ***

2

It’s possible to have more information please

3

okay i have some option fields in my table and for a user-search formular i want to give the user a selection-help … so i need to read the current optionstring (all the possible values for this field) out of a option field and put it in a text-variable … *** quack ***

4

If you want to put the current value of the option field use the “FORMAT” function TXT:=format(OPTIONField);

5

thx but i don’t want the value … i want the text stored in the property: optionstring of the option field … *** quack ***

6

in a form put the optionstring propertie non editable

7

mmmh i don’t think you understand me … i have a textbox as optionfield which drops down an lets the user choose out of its values which are stored in its property optionstring … so now i want to get this options string (the comma-seperated string and not one value!) using some code … should be look like this : txt := field.optionstring() and in txt should be shown something like value1,value2,value3,… and so on … *** quack ***

8

If you know the number of options in the option string then run through the values formatting each one.


FOR i := 0 to N DO BEGIN
  Record.OptionField := i;
  OptionString := OptionString + ',' + FORMAT(Record.OptionField);
END;
OptionString := COPYSTR(OptionString,2);

Edited by - Jack Reynolds on 2001 Dec 13 13:59:55