Description
Properties that control the appearance and behavior of a column with the DropDownListBox edit style.
Applies to
Column controls
Syntax
PowerBuilder dot notation:
dw_control.Object.columnname.ddlb.property
Describe and Modify argument:
"columnname.ddlb.property { = value }"
|
Parameter |
Description |
|---|---|
|
columnname |
The name of a column that has the DropDownListBox edit style. |
|
property |
A property for the DropDownListBox column. Properties and their settings are listed in the table below. |
|
value |
The value to be assigned to the property. For ddlb properties, value cannot be a DataWindow expression. |
|
Property for ddlb |
Value |
|---|---|
|
AllowEdit |
Whether the user can type a value as well as choose from the DropDownListBox's list. Values are: Yes -- Typing is allowed. No -- (Default) Typing is not allowed. Painter: Allow Editing option. |
|
AutoHScroll |
Whether the DropDownListBox automatically scrolls horizontally when the user enters or deletes data. Values are: Yes -- (Default) Scroll horizontally automatically. No -- Do not scroll automatically. Painter: Auto Horizontal Scroll option. |
|
AutoCompleteMode |
The option that controls how automatic completion works for the DropDownListBox. Values are: None -- Disables automatic completion. Suggest -- Displays the auxiliary list associated with the entered characters with one or more suggested completion strings. The entered characters are case-insensitive. Append -- Appends the remainder of the most likely candidate string to the entered characters, highlighting the appended characters. The entered characters are case-insensitive. SuggestAppend -- Enables both Suggest and Append options. Note1) When AllowEdit is set to No by default, the column ignores the AutoCompleteMode property and the option list never displays. 2) If you have added scripts to implement the auto-complete feature, for example, filtering data according to the input value in the EditChanged event, then you should not enable the AutoCompleteMode option. 3) If the Append option is enabled, the EditChanged event will be triggered twice. The first trigger occurs when the appended characters need to be deleted, and the second trigger occurs when the new input characters is populated. Painter: AutoCompleteMode option. |
|
Case |
The case of the text in the DropDownListBox. Values are: Any -- Character of any case allowed. Upper -- Characters converted to uppercase. Lower -- Characters converted to lowercase. Painter: Case option. |
|
Limit |
An integer from 0 - 32767 specifying the maximum number of characters that can be entered in the DropDownListBox. Zero means unlimited. Note that when AllowEdit is set to No by default, the column ignores the Limit property. Painter: Limit option. |
|
NilIsNull |
Whether to set the data value of the DropDownListBox to null when the user leaves the edit box blank. Values are: Yes -- Make the empty string null. No -- Do not make the empty string null. Painter: Empty string is null option. |
|
Required |
Whether the column is required. Values are: Yes -- Required. No -- (Default) Not required. Painter: Required option. |
|
ShowList |
Whether the ListBox portion of the DropDownListBox displays when the column has focus. A down arrow does not display at the right end of the DropDownListBox when ddlb.ShowList is yes. Values are: Yes -- Display the list whenever the column has focus. No -- Do not display the list until the user selects the column. Painter: Always Show List option. |
|
Sorted |
Whether the list in the DropDownListBox is sorted. Values are: Yes -- The list is sorted. No -- The list is not sorted. Painter: Sorted option. |
|
UseAsBorder |
Whether a down arrow displays at the right end of the DropDownListBox. Values are: Yes -- Display the arrow. No -- Do not display the arrow. Note that if ShowList is set to Yes, the column ignores the UseAsBorder property and the arrow never displays. Painter: Always Show Arrow option. |
|
Validation |
Whether to check if the value entered in the DropDownListBox exists in the dropdown list; and if the value does not exist, the user will be prompted to enter a different value. Values are: Yes -- Check if the value exists. No -- Do not check if the value exists. Painter: Validate value against dropdown choices option. |
|
VScrollBar |
Whether a vertical scroll bar displays in the DropDownListBox for long lists. Values are: Yes -- Display a vertical scroll bar. No -- Do not display a vertical scroll bar. Painter: Vertical Scroll Bar option. |
Usage
In the painter
Select the control and set the value in the Properties view, Edit tab, when Style Type is DropDownListBox.
Examples
ls_data = dw1.Describe("emp_status.ddlb.AllowEdit")
dw1.Modify("emp_status.ddlb.Case='Any'")
dw1.Modify("emp_status.ddlb.Limit=30")
string ls_data
ls_data = dw1.Object.emp_status.ddlb.AllowEdit
dw1.Object.emp_status.ddlb.Case = "Any"