List

Kalipso - Developing - Form - Controls - Type - List

A List 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

Tab - General

Common

  • 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.

Miscellaneous

  • Input Type - Type of Input Box

    • Alpha - The Input Box will accept alphanumeric chars.

    • Numeric - The Input Box will only accept numeric chars.

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.

  • Row Height - Height of the row.

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 appear:

  • Styles

    • None

    • Base

Text

  • Font – Font of the displayed Text

  • Size – Font size of the displayed Text

  • Color - Font color of the displayed Text

  • Properties – Font properties of the displayed Text (bold, italic, underline)

Border

  • Border - Yes or No

Advanced Style

  • Selected Text - Chose the color for the selected text

  • Selected Rows - Chose the color for the selected rows

  • Odd Rows - Chose the color for the odd rows

  • Even Rows - Chose the color for the even rows

  • Multiline - Check box to make each row a multiline text row

Tab - Content

Regarding the content to be inserted in this control, it can be divided into three types: nothing, tables or advanced SQL. Choosing a type, the information in the window changes by questioning different options. Thus, you can link controls to:

  • None - The control will be empty by default.

  • Database Table - The control will be linked to a Database Table and the number of records will be the same as the source Database Table. For the data to be displayed, "Refresh Control" Action must be called.

When clicking on the database table option without having entered data in a table, the system immediately alerts you with the following message:

You cannot load the Control with a Database Table because you haven't Added/Created any Table.

  • SQL Advanced - You can use SQL Advance to fill the combobox.

Predefined Options

  • No - It does not define initial options.

  • At Beginning - At the beginning of the line

  • At End - At the end of the line

Table

  • Displayed Value - Value that appears as an option

  • Returnend Value - Relation of the value that appears as an option with the field in the database.

You can remove or load more options by clicking the buttons on the right in the table.

When clicking on the load options option, a pop-up window appears with the following possibilities for filling. These options allow the inclusion of default settings in the combobox, such as printers and terminal communication types.

  • Printer Type

  • Printer Communication Type

    • IRDA

    • Cable

    • Bluetooth

    • TCP/IP

    • Bluetooth Socket

  • Baud Rate for

    • Printer

    • Serial Port

  • Data Bits

  • Stop Bits

  • Parity

  • Connection Manager -

  • Project Languages -

Links can be associated with this control. For this, the source must be indicated for them. These can be loaded in two types: database and expression.

  • Source - Origin of the data to show in the Input Box

    • Database - Connect the Input Box with a Column of a Database Table.

    • Expression - Fill the Input Box with the result of an Expression.

When choosing database the options are:

There are two ways of connecting your Input Box to a Database 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>

When choosing expression the options are:

A new field is active to be filled in where you are asked to fill in the controlog with the result of ...

  • Target (store the control's Value in) 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;

    • Column – Column where to store the Input Box value;

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.‌‌

Shortcuts‌

  • F2 - Actions

  • F3 - General Properties

Last updated