QUERYEDITABLE attribute
The QUERYEDITABLE attribute makes a COMBOBOX field
editable during a CONSTRUCT statement.
Syntax
QUERYEDITABLEUsage
The 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").
It is not recommended to use the 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.