Textbox with dropdown

 Show all Hide all

Textbox with dropdown

Start value: Start text
Return value: Selected or entered text

Control container: NewEdit

Supported in: NewEdit Multirow


SQL Call: Retrieve values (mandatory)

SQL-statement that fills the dropdown-control with possible values.

May modify database: No

Resultset: Values

Repeat mode: repeated exactly once
Row count: zero or more rows


<column with ordinal 1> mandatory string
Value to insert in textbox when the user selects it from the dropdown.
<column with ordinal 2> optional string
Text to show in dropdown.
Default: If omitted the value of the first column will be shown in the dropdown.

Default value

SQL Call: Default value

Retrieves the default value for the control.

May modify database: No

Resultset: Default value

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


<column with ordinal 1> mandatory string
The default value


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


@Value string
The value of the field, the procedure will not be called if value is NULL.

Resultset: Validation messages (optional)

Repeat mode: repeated zero or one time
Row count: zero or one row


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

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>TextboxWithDropdown". If it is not and the values are not directly linked to rows in a table (say for instance you want to retrieve previously used values) then the procedure should be named "<Schema>.<Table><Field>_TextboxWithDropdown".