Simple Widgets

Simple widgets are one-line widgets for input of e.g. strings, numbers or dates.

String input

Simply type the string you want in the provided field.

Number input (integer or decimal numbers)

Simply type the number into the field. Local settings for group and decimal separators are applied, so if you set the decimal separator on your computer to , you must not use .. Any number saved is displayed in the same way in the first place (with group separator and decimal separator). The group separator may be placed anywhere, it is simply ignored, because numbers are saved without it in the database.

Foreign key input (normally integer)

Foreign keys are input via combo boxes. The combo box shows the values from the first NOT NULL varchar field in the related table. If there is none such field the values from the table's key field are shown. Upon typing into the combo box the first matching input value is highlighted.

User class of a foreign key input depending on user input into another combo box

In cases where the choice of a combo box should be changed by the input made in another combo box you can use the user class DdRelatedComboBox. For example reduce the addresses in a combo box when the user chooses a street name in another combo to those addresses being located in this very street. Use DdManager's addInputWidget() or replaceInputWidget() methods if you want to use this feature.

Date input

For date input a calendar widget is provided; the date is displayed according to your local settings.

Boolean input

Click either yes or no to save true or false.

Geometry field

The current feature's geometry's area or length ist shown in the mask. Of course it cannot be edited. You can suppress the display of area/length by skipping the field in the mask.

NULL values

NULL is the absence of a value, therefore it is totally different from 0 (zero) or an empty string! To save a NULL simply tick the null checkbox in the right of the line. While the checkbox is ticked the input widget (e.g. text line) is inactive and no value at all can be entered. To reenable the input widget either double-click on it or untick the null checkbox. If the null checkbox is absent the field is defined as NOT NULL, i.e. some value has to be entered.