Lets the user choose a value from a set of radio buttons with predefined values.
The values can be combined with friendly labels, and in that case
the labels will be displayed to the user instead of the value.
Start value:
The value of the preselected radio button.
Return value:
The value of the selected radio button.
Supported in:
NewEdit
Parameter page
Multirow
Appearance
SQL
SQL Call: Retrieve values
SQL-statement that fills the control with possible values.
May modify database:
No
Resultset: Values
Values for control.
Table count:
repeated exactly once
Row count:
zero or more rows
Columns
<column with ordinal 1>
mandatory
string
Possible values in list (also displayed values if column at ordinal 2 is omitted)
<column with ordinal 2>
optional
string
Displayed values in list (if column is omitted values from column at ordinal 1 is used)
Html
optional
string
Displayed values in list (if column is omitted values from column at ordinal 1 is used). Use this column if you need to display html inside the radio button label. This column should have ordinal 2, i.e. this column is used instead of the previous ordinal 2 column.
HideUnlessCurrent
optional
bit
This column indicates that the value should only be shown as an option if it is the currently chosen value.
Default value
SQL Call: Default value
Retrieves the default value for the control.
May modify database:
No
Resultset: Default value
Table count:
repeated exactly once
Row count:
exactly one row
Columns
<column with ordinal 1>
mandatory
string
The default value
Validation
SQL Call: Validation
This call is only made if there is a field validation set for the field info and the field has any content.
Live Validation
Performs field validation when the user leaves the field or one of its dependencies is changed, initial values set by default value and initial values in edit-mode are not validated.
Save Validation
When saving the validation runs server side if the field value has changed. A field value is considered changed if in new mode the value is anything other than NULL
. In edit mode it is considered changed if it has a value that was not returned by the GetEditFields procedure.
May modify database:
No
Parameters
@Value
string
The value of the field, the procedure will not be called if value is NULL.
Resultset: Validation messages
(optional)
Table count:
repeated zero or one time
Row count:
zero or one row
Columns
Error
optional
string
Error message to display. Blocks the user from saving.
Info
optional
string
Informative message to display. Does not block saving.
Warning
optional
string
Warning message to display. Does not block saving.
Best practice
Always use an explicit ORDER BY
For stable and predictable behaviour, always use an explicit ORDER BY clause.
Name of stored procedure
The name depends on the usage. If the control is used to retrieve values from a lookup table then the procedure should be named "<Schema>.<LookupTable>Dropdown". If it is not and the values are not directly linked to rows in a table or the functionality is specific for the current field (say for instance a choice between each of the last six years) then the procedure should be named "<Schema>.<Table><Field>_Dropdown".