User Tools

Site Tools


picklist:start

Pick Lists with Multiple Source of Data

Pick lists in a combo box could be populated by:

  • A String variable containing a comma-separated list, like,
     "Yes,No,Don't Know"
  • A code list specified by code <Code-Type>, like,
     code Customer Group
  • A SQL statement, like,
     select xgitem from caitem group by xgitem

When a pick list is to be populated by combining multiple sources, separate each source-specs by double semi-colon “;;”. For instance,

"Yes, No, Don't Know";;code Customer Group;;select xgitem from caitem

If you are incorporating a combo box in a menu, you need to replace special characters with their equivalent ascii character-based #char function. For instance, to combine the first two sources, specify

 
 ... xgitem=Delivery Option=All=combo="+#char(34)+"Yes,No, Don't Know"+#char(34)+";;code Customer Group)" ...
/srv/www/htdocs/wiki/data/pages/picklist/start.txt · Last modified: 2012/10/24 01:34 (external edit)