BS: if you work width dropdown-sql-command, you can define the design of the dropdown-list direct in the sql-statement
select (field=fieldname,propertie=value,propertie=value.../) from table
select (field=fieldname<tab>propertie=value<tab>propertie=value.../) from table
You must start the definition allways with (field= and end with /)
Properties
field |
SQL-Fieldname (don't use Comma) you need an mandatory field name you can set the field type and the field name with (C) for Char and N for Number example select ("ItemName"(C)itemname<tab>title=Description/) from "OITM" Beas converts this syntax (MSSQL) to select ItemName+'' as itemname from OITM and in HANA select "ItemName"||'' as itemname from "OITM"
or you can work with select (field=ItemName||''<tab>name=itemname<tab>title=Description/) from "OITM") wrong is select (field=ItemName'<tab>name=itemname<tab>title=Description/) from "OITM") (without ||) because then the name-result is "OITM_ItemName" or "ItemName" - it's not defined.
Use always HANA-Format. See select |
name |
internal Name Beas sets "<fieldname> as <name>" in the SQL statement |
title |
set the title if you set min. 1 title, Beas insert a title-header |
width |
the width of column if not set, Beas uses 300 pixel this information is the minimal entry. Beas checks the first 50 entries to calculate the optimal width |
height |
set the height You can work with formular. don't use Comma. Use "|" for Comma Example: if (id=1|50|100) or you use <tab> as delimieter in the field-description |
format |
the Format: timenum, quantity, mass, price, date, datetime, time, c:<unitfieldname> Fix format, example #,#0.00 Special format: bmp = make this as picture |
expression |
create a formular field |
visible |
0 = make unvisible |
weight |
set weight 0 = normal, 1 or 700 = big weight if(id=1,0,700) = width formular |
italic |
set italic (see weight) |
color |
set color (see weight) |
alignment |
set alignment: left, right, center |