The SQL statement must return 3 columns:
a) the ID
b) the Description
c) optional a picture reference or empty string
Parameters can be inserted in [...]
If no SQL statement is defined, you can insert manual values. See tab Values.
Example:
select "ItemCode", "ItemName",'' from "OITM" where "U_gruppe" = '[group]'
Note:
When using dropdown lists, it may possibly be useful to suppress the return value from the displayed list.
This could be realized via the output formatting of the return value (see BeasScript manual).
select "ItemCode" as itemcode__1, "ItemName",'' from "OITM" where "U_gruppe" = '[group]'
|