Boolean Dropdown
Lets the user choose from the values 'True', 'False' and 'Unspecified' using a dropdown. The last choice is omitted if the field does not allow null values.
Start value:
The value that is preselected in the dropdown. Possible values are '0', '1' and NULL.
Return value:
The value that is selected in the list (not the displayed value), i.e. '0', '1' or NULL.
Supported in:
NewEdit
Parameter page
Multirow
Editable Grid
Appearance

- Appearance when closed.
- Clicking the control reveals the two options. The language in the drop down list will match the logged on user's language setting.
- A boolean dropdown can also have a "no value" choice, in which case the red star is not shown.
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. Fields used in an editable grid do not use this call.
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.