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