Command: SetValidValues |
Previous Next | Direct link to this topic |
|
Syntax: SetValidValues($[$<item>.0.0]|<SQL>);
Set a custom set of valid values in an item that accept valid values (Example a combo box). This is ofter used together with command ClearValidValues
Sample1: SetValidValues($[$MyUID.0.0]|SQL:SELECT CurrCode, CurrName FROM OCRN); will show all currencies as valid values in combo box “MyUid”.
Sample2: SetValidValues($[$MyUID.0.0]|SQL:SELECT '', '' UNION ALL SELECT Code, Name FROM OCRY); will show all countries including an empty value in the top in combo box “MyUid”
NB: SetValidValues only works on header-level items. NB: This cannot be done on system items Video: How to use Set and Clear Valid Values | Video 2
Similar/Related Commands: |