Looper - Kalipso

Contents Index

Looper

A Looper is a Table with Controls. You can define the content of the Looper and it will repeat itself according to the number of the records to display. You can add records manually or through the database, just like a Table. A Looper can interact with the user through its Events. You should use a Looper when you need to present an item composed with information that needs to be displayed en separated fields (columns) and when you need them to be from various types or want to position them freely.

Value - It has no value.

Properties - General

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 (_).

Description – Description of the Control
This Description is for your information only, Kalipso does nothing with it. If you click on

at the side of this property, you’ll be able to set the value in each Language of the Project.

Plane – Plane of the Form where the Control should be created
Check the Planes chapter for more information.

Width – Width of the Control
You can set this value is runtime via the “Set Property” Action. You can retrieve this value in runtime via the “Get Property” Action. If you click on

at the side of this property, you’ll be able to set the value of it in both Portrait and Landscape orientation (see the Project Properties).

Height – Height of the Control
You can set this value is runtime via the “Set Property” Action. You can retrieve this value in runtime via the “Get Property” Action. If you click on

at the side of this property, you’ll be able to set the value of it in both Portrait and Landscape orientation (see the Project Properties).

From Left – X position of the Control
You can set this value is runtime via the “Set Property” Action. You can retrieve this value in runtime via the “Get Property” Action. If you click on

at the side of this property, you’ll be able to set the value of it in both Portrait and Landscape orientation (see the Project Properties).

From Top – Y position of the Control
You can set this value is runtime via the “Set Property” Action. You can retrieve this value in runtime via the “Get Property” Action. If you click on

at the side of this property, you’ll be able to set the value of it in both Portrait and Landscape orientation (see the Project Properties).

STYLE

Embed page 'style_Border' not found.

Backg. Color – Background color of the Looper
You can set this value is runtime via the “Set Property” Action. You can retrieve this value in runtime via the “Get Property” Action.

Orientation – Specifies how the scroll of the Looper is handled
Select Vertical to repeat the cell content from top to bottom. Select Horizontal to repeat the cell content from left to right.

Number of Columns – Number of parallel repetitions of the Looper content before advancing in the specified Orientation.

Cell Width – Width of the area to repeat.

Cell Height – Height of the area to repeat.

Selection Style – How to display to the user which cell is selected.

Border - A line is drawn around the cell
Background - The background of the cell is painted with the specified color

Selection color - Color of the line or of the background of the cell when it's selected

Properties - Content

Link Controls to:

Nothing - The control will be empty by default but you can use "Looper Add Line" Action to populate it.
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.

Kalipso Syntax - A slightly different form of SQL. Everything remains the same but instead of single-quotes to enclosure string types, you should use double-quotes. When referring to Controls or Variables, quoting is not needed.
String Expression - A string expression who will be evaluated and the result is executed over the database. You are responsible by specifying a result with the syntax expected by the database. Quoting is also your responsibility.
Filter - "Where" clause to be applied in the "select" to the Database Table.
Order By - "Order By" to be applied in the "select" to the Database Table.

SQL Advanced - You're able to define the query that fills the control. The query should return a column for each link.

Database Profile - Database connection over which the specified query should be executed. You only need to specify one if it's online.
Query - String expression who will be evaluated and the result executed over the database.

Links - Connections between the Looper controls and the database. You can define a link between any editable property of a control belonging to the Looper and the Database. When the source is set to "Database Table", the link source is a Column. When the source is set to "SQL Advanced", the link source is the index of the returned column in the query.

Properties - Relations

This option allows you to define the relation between tables selected as source in Content.

Usage

Assume the following database:

Products		Families
Code		Code
Name		Name
Price

Assume the following properties of your Table (Grid):

Link Control to: Database Table
Links:

Table	Column
Products	Name
Products	Price
Families	Name

Relations:

Products	Families
Code	Code

Shortcuts

F2 – Actions

F3 – General properties