dropdown=fieldname
dropdown=dw_x.fieldname (beas9.1 PL:8)
dw_x.item.dropdown (beas9.2 PL:6)
open the dropdown window
Will be used for e.g. Bitmaps.
The DropDown Information will be provided with Field properties. ( use Strg+N+N on the Field )
Attention: this are old function. Please work with item.<itemname>.dropdown. More Information
See item
Commands:
ddsql=sql-command |
Describes the SQL Statement for the DDDW
you can define the output-format in the field-description |
||
ddfelder=field=Index=width,feld=Index.. |
|
||
ddeingabe=.. |
Show Input field |
||
ddreturn=fromfield=tofield |
Optional: Describes a Field mapping. Which DataWindow Field should be mapped to which Target Field. |
||
ddwidth=breite |
Optional: Width of the DrowpDown. Reserves a extra of 50 Pixel for Scrollbars. |
||
dditem=field=value,field=value.. |
Fill DataWindow by hand if not working with "Values" Example: ddsql=select rpad(' ',50) as valuesid dditem=valuesid=red dditem=valuesid=yellow Attention: use hana-format. See select |
||
ddscript=<beascipt> |
Optional: This Script will be executed before the Selection Form will be opened. You can specify more than one line. |
||
ddok=<beasscript> |
Optional: This Script will be executed after a successful selection. |
||
ddemptyrow |
insert an empty row |
||
ddfilter=<sql-filter> |
replace the text "(filter)" in the sql-statement |
||
ddreturnfields=fieldname,fieldname |
|
||
ddvar=variable=value |
|
Alternative you can put the Syntax into the variable "dropdown:<feldname>".
This would be mostly used for specific Customer customizing since this Alternative has a higher Priority inside the Engine.
if you need more then one command, then you can define the next parameter with <tab>
<
setvar=dropdown:itemcode=ddsql=select "ItemCode","ItemName" from "OITM"<tab>ddreturnfields=result1,result2
If the selection criteria has been deposit into the Edit Values than you need to use "ddsql=*"
Examples:
(old version! Please work with item)
// In connection with a value SQL Statement
ddsql=select "ME_ID" from "ME"
// In connection with a variable
setvar=dropdown:me_id=ddsql=select "ME_ID" from "BEAS_ME"