sysselect

syselect provides support for the <select><option>.</select> HTML form object.

object record

sysobjects (sysselect)

Field

Description

Information

  Security Groups  
  Module  
<2> Description  
<4.1> Data field  
<4.2> Dependant field  
<4.3> VM delimited This option allows the user to specify that the Data Field value is either specified as a VM (value marked) delimitered list or a SVM (sub-value marked) delimitered list. This option also affects how the data stored in the text box gets saved.
<4.4> Invisible  
<10.1> Selection type This option defines the mechanism for populating the selection box. Valid options are:
  • User - user defined.
  • File - use the contents of a file for the selection box options.
  • Item - Use a multi-valued item within a record or the selection box options.
  • Select - Use a pre-defined selection (as specified within the sysselopts) object. (For compatibility use only!)
  • Mvsel - Use the multi-valued contents of a common block memory item for the selection box options.
<10.2> Selection options Used in conjunction with the Selection type property. See below for examples.
<10.3> Selection height The height of the selection box in lines. If set to null or 1, the selection box functions as a normal "drop down" selection box. If set to 2 or more, the selection box becomes a list box. NB: This property does not get displayed if a selection width is not applied.
<10.4> Multi-select If set (and used in conjunction with a selection box height of more than 1), the selection box will allow multiple selections using the shift and control keys. These items will be returned into the data field (sysdata, syshidden or sysperm) as a sub-valued list. If the MV Swap option is selected, then the values will be returned as a multi-valued list
<10.5> Nulls allowed If set, an initial null value item will always be present within the option list. This allows the user to "un-select" the item and return its value to null.
<10.6> Null display The text stored within this element will be used in place of the default "[None]" value that is normally used to indicate a null value
<10.7> Default value The text stored within this element will be compared to the option return values and will determine which option will be selected if the sysdefault value is active
<10.8> HTML tag inclusion  
<10.9> Focus event  
<10.10> Change event  
<10.11> Blur event  
<10.12> Fixed width font If set, this item changes the default font of the selection box to "courier new", which is a fixed width font.

Changing the font to fixed width supports the manipulation of a selection box so that it can contain columns of information. 

Other settings that are required for this mechanism to work include a selection box height of 2 or more, and the conversion of spaces for option display text to "&nbsp;" (non breaking spaces). This item makes use of Style Sheets.
<10.13> Style  
<10.14> Style class  
<10.15> Selection width The width of the selection box in pixels. This item makes use of Style Sheets.
<10.16> Display conversion This option applies an OCONV format to the display text. See the jBASE knowledgebase for more information on OCONV formats.
<10.17> Tool tip  

 

Selection Options property

User
Format
display value 1||return value 1&&display value 2||return value 2 etc
Parameters
The "||" items delimit display and return values and the "&&" items delimit each individual selection item in the list of options.
Examples
Salt||S&&Mustard||M&&Vinegar||V&&Pepper||P
File
Format
<filename>,<field>,<criteria>
Parameters
  • Filename - the name of an existing jBASE file
  • Field - The field within the file for each record that will be used for the display portion of the option. This may also be specified with the syntax "combo:field:field:....;delimeter:delimeter:..." which is used to make a composite display item of the fields to display as specified between the colons. Any numer of fields may be specified followed by a semi-colon, and then colon separated display delimiters.
  • Criteria - An executable jQL statement to select the item IDs from the file for inclusion in the selection box. DIRT tags may be used within this statement. More information on jQL can be found in the jBASE knowledgebase.
Examples
sysusers,combo:0:1;():-,SSELECT sysusers LIKE "a..."

displays:

(id,value) - field 1 value

Item
Format
<filename>,<itemid>,<displayfield>,<returnfield>
Parameters
  • Filename - an existing jBASE file
  • Item ID - A valid record key that exists in this file
  • Display field - The field position of a multi-valued field which contains the display text
  • Return field - The field position of a multi-valued field which contains the corresponding return text.
Examples
syscontrols,parms,15,16
Select
DEPRECATED - included for backwards compatibility only
MVSel
Format
<variable>,<displayfield>,<returnfield>
Parameters
  • Variable - Any common block variable (eg sysdata, syshidden etc)
  • Display field - The field position within the common block variable which contains the list of items for display.
  • Return field - The field position within the common block variable which contains the list of items to return.
Examples
syshidden,1,2