DropDown

Dropdown allow you to choose a value from List

3  concepts existing

 

1. The list of Id+Display text defined inside the field. In the Input field you see only the Display text, but the ID is saved
Use this type, if the simple variant is enough or if you don't want to see the ID

Note: if SQL command needed, then it take more time to open a window

dropdownVariant1

2. In dropdown you see the Id and additional fields  and choose the Id
This list is created in the moment of the view of the list

This variant don't reduce the performance from the program. Use this variant if possible

Source can be
- manual values
- sql select command

- odata (bsl) command

dropdownformat

3. Other type of Dropdown as Date, Bitmap or Color

dropdownCalendar     dropdownBmp dropdownColor

 

 

If dropdown value defined, the system insert automatically the dropdown icon right of the field
Object name of this dropdown icon is always object name + "_p", example "utf1_p"

 

It is possible to modify standard dropdowns. See dropdown.script

 

Open dropdown window:: use dropdown without properties:

dw_1.item.myfield.dropdown

 

Define Dropdown properties

Property

Description

dropdown.addvalues

Add Values to the current value-List

dropdown.filedir

Load files from directory or from reports

dropdown.format

Define Type and Format of Dropdown window

dropdown.formatvalues

define manuel data for formated dropdown

dropdown.fromdw

Create a dropdown field from other dw

dropdown.fromfield=<column2>

copy the values from other field to the current field

dropdown.select=<selectcommand>

Greate dropodown from select command

dropdown.bsl=<odata>

Activate DropDown from ODATA command (beas service layer)

dropdown.setvalues=<values>

set value list directly in datawindowformat

dropdown.translate

Translate all Value Entrys from the value-List

dropdown.script

Send script to the dropdown window after creation

dropdown.values=..

Define Values for the field