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 " "
(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
|
|
sysselect