Control: Radio buttons

 Show all Hide all

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.

Control container: NewEdit

Supported in: NewEdit Parameter page Multirow

SQL

SQL Call: Retrieve values

SQL-statement that fills the control with possible values.
Supports custom errors: No
May modify database: No

Resultset: Values

Values for control.
Repeat mode: 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)

Default value

SQL Call: Default value

Retrieves the default value for the control.
Supports custom errors: No
May modify database: No

Resultset: Default value

Repeat mode: repeated exactly once
Row count: exactly one row

Columns:

<column with ordinal 1> mandatory string
The default value

Validation

SQL Call: Validation

Performs field validation when the user leaves the field or one of its dependencies is changed. This call is only made if there is a field validation of type SQL set for the field info.
Supports custom errors: No
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

Repeat mode: 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.

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".