QUERYEDITABLE attribute
The QUERYEDITABLE attribute makes a COMBOBOX field editable
during a CONSTRUCT statement.
Syntax
QUERYEDITABLEUsage
QUERYEDITABLE attribute is effective only during a
CONSTRUCT statement. This attribute is useful when the display values match the
real values in the ITEMS attribute, for example when
ITEMS=("Paris","London","Madrid").QUERYEDITABLE attribute, when the real field values are mapped to key/label
values in the ITEMS attribute. For example with
ITEMS=((1,"Paris"),(2,"London"),(3,"Madrid")).During a CONSTRUCT, a COMBOBOX is not editable by
default. The end-user is forced to set one of the values of the list as defined by the
ITEMS attribute, or set the 'empty' item.
The QUERYEDITABLE attribute can be used to force the
COMBOBOX to be editable during a CONSTRUCT instruction, in order
to allow free search criterion input such as "A*".
If QUERYEDITABLE is used and the ITEMS are defined with
key/label combinations, the text entered by the user will be automatically searched in the list of
items. If a label corresponds, the key will be used in the SQL criterion, otherwise the entered text
will be used as is. For example, if the items are defined as
ITEMS=((1,"Paris"),(2,"Madrid"),(3,"London")), and the user enters
"Paris" in the field, the item (1,"Paris") will match and will
produce the SQL condition "colname = 1". If the user enters ">2", the text
does not match any item, so it will be used as is and the SQL condition "colname > 2" is
produced. Users may enter values like "Par*", but in this case the runtime system
will raise an error, because this criterion is not valid for the numeric data type of the field. To
avoid end-user confusion, it is not recommended to combine the QUERYEDITABLE
attribute with a COMBOBOX defined with key/label combinations.