|
| | |
|
|
A Check Box is a frame with 2 statuses: check or unchecked. A Check Box can have a text. You can also link a Check Box to the Database. A Check Box can interact with the user through its Events. You should use a Check Box to display true/false options or fields.
Value - Its value is either 1 (checked) or 0 (unchecked).
|
| Properties - Links |
|
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:09 PM |
| |
|
|
|
at the right side of this property, you’ll be able to set the value in each Language of the Project.
