Table (Grid)
Kalipso - Developing - Form - Controls - Type - Table (Grid)
A Table is a multi-column List Box. Unlike List Boxes, Tables can have a Header and can be editable. You can load a Table with data from the Database or using the ‘Table Add Line’ Action. A Table can interact with the user through its Events. You should use a Table when you need to present an item composed with information that needs to be displayed en separated fields (columns). Value - It has no value.
For the control in question, when opening its properties, the following window appears:
Depending on the control chosen, the properties are different.
Properties
Tab - General
Name - Name of the Control. This Name will be used to identify the Control throughout the Project. The name of the Control can only contain letters, digits or underscore (_).
Text - Not applicable to this control.
Description - Not applicable to this control.
Plane - Plane of the Form where the Control should be created. Check the Planes chapter for more information.
Visible - With this option selected, the control is (or is not) visible.
Enabled - With this option selected, the control is (or is not) enabled. It may be visible (previous option), but it may not be enabled. In this case an event associated with the control is not executed
Layout
X - x position of the Control from left
Y - y position of the Control from top
Width - Width of the Control.
Height - Height of the Control
In relation to all these layout options, it is possible to set this value in runtime via the “Set Property” Action. You can also retrieve this value in runtime via the “Get Property” Action.
Style
Appearance
Background - Background color of the Control. You can set the color for the background.
Opacity - Set the percentage of opacity for the background.
Grid Lines - To activate or deactivate the Grid Lines of the table. In Win32 clients, without advanced style, it can only be none or both (vertical+horizontal).
Line Color - Color of table lines.
You can set this value is runtime via the “Set Property” Action. You can retrieve this value in runtime via the “Get Property” Action.
On the right side of the Style section, you can choose templates with pre-defined styles or configurable ones. By clicking on this option, the following style possibilities for the label appear:
Styles
None
Base
Text
Font - Font of the displayed Text
Size - Font size of the displayed Text
Font Color - Font color of the displayed Text and/or select the code in the color picker.
Font properties - Set of options where you can choose whether the font is bold, italic or underline
Border
Border - Yes or No.
Header (you can activate or not this feature)
Background - Background color of the header
Text - Text color of the header
Advanced Style (you can activate or not this feature)
Row Height - Define the height for the row
Docked Columns - Define the number of docked columns
Transparent Background - Set the background transparent
Odd Row - Chose the color for the odd row
Even Row - Chose the color for the even row
Selection Mode - Chose between row or cell
Editable - If in the previous option you chose cell then this field is active. So it is possible to chose:
No
On Click
On double Click
On Click or ENTER
On double Click
On ENTER
By Action Only
Selected Row - Chose the color for the selected row
Selected Text - Chose the color for the selected text
Tab - Content
When accessing this tab, the system presents options to load the control through three sources.
Load controls from:
Nothing - If select it will use the Kalipso database if filled.
Tables - You can use data of one of the database you have imported
SQL Advanced - You can use SQL Advance to fill the combo box.
In the table the necessary fields for the name, title, type, etc. are filled in. You can add and edit table columns.
For each tab, the options available are:
Tables
Kalipso Syntax
String Expression
Filter
Order By
SQL Advanced
Database Profile - Choose the desired pre existing profile
SQL statement - Field to insert the SQL
LIMIT and OFFSET: internally Kalipso already uses "LIMIT 200 OFFSET 0". So if you need to use your own LIMIT and OFFSET you need to do: SELECT * FROM ( YOUR QUERY)
Ex:
"SELECT * FROM (SELECT trackId, name FROM tracks LIMIT 10 OFFSET 10)"
Tab - Relations
You can use this option to link tables when you are using more than a Table to fill this object. This option is related to the one defined in the previous tab related to the content.
Having database tables associated with the table provided here, these tables will appear in this tabulation to make relations between them.
Tab - Actions
For each control, actions can be associated. For this, with the control selected, it is possible to access this tab and associate an action to the control. For more information on the actions available and how to use them click here.
In order to save and use this control, you must, in the content tab, establish the source of the data. If not, Kalipso will not allow you to save.
Shortcuts
F2 - Actions
F3 - General Properties
Last updated