|
| | |
|
|
A List Box is a frame that can contain a list of items, displayed one per line. A List Box can be loaded with data from the Database and/or with fixed Options. You can also link a List Box to the Database. A List Box can interact with the user through its Events. List Boxes are useful to show a list of items without the need of additional columns.
Value - It has no value.
|
Properties - Link |
Source – Origin of the data to show in the Input Box
- Nothing: Empty Input Box (depends on the “Input Type” property).
- Database Table: Connect the Input Box with a Column of a Database Table.
- Expression: Fill the Input Box with the result of an Expression.
Source: Database Table
|
There are two ways of connecting your Input Box to a Database Table therefore presenting the value of a specific Column.
1 – You can do it by simply defining the "Table" and "Column" properties and then using the "First Record"/"Last Record"/"Next Record"/"Previous Record" and "Refresh"/"Refresh Plane"/"Refresh Control" Actions.
2 – The other way is to implicitly define a "Select" statement. To do so, you have to define the "Table", "Column", "Where the value of" and "It’s equal to" properties then use the Refresh", "Refresh Plane" or "Refresh Control" Action. This way you are telling Kalipso to perform a "Select" statement like this:
Select <Column> from <Table> where <Where the value of> = <It’s equal to>
|
|
Source: Expression
|
Fill the Control with the result of – Expression whom result will be shown in the Input Box
For the Expression to be evaluated and fill the Input Box you’ll have to perform a "Refresh", "Refresh Plane" or "Refresh Control" Action.
|
|
Target
|
Mandatory – To define if the Input Box must be filled or not when performing a “Create Record”, “Update Record” or “Create/Update Record” Action.
If this property is set, when Kalipso tries to use the value of this Input Box for executing one of the above Actions, it checks if the value is non empty; if it’s not, Kalipso will produce an automatic error message.
Global Variable – Global Variable where to store the Input Box value;
Local Variable – Local Variable where to store the Input Box value;
Database Table – Table where to store the Input Box value;
Database Column – Column where to store the Input Box value;
The Input Box value is retrieved and stored in the corresponding Database Table and Column when you execute a Create Record”, “Update Record” or “Create/Update Record” Action on the “Database Table”.
|
|
|
|
Shortcuts |
F2 – Actions
F3 – General properties
|
|
|
|
Updated: 5/6/2016 3:10 PM |
| |
|
|
|