Local

Kalipso - Developing - Form - Database Connection Profiles - Tables - Local

When you add Tables to this Profile, you are defining a Database Table (from scratch) that only exists on the device where the developed Project is running.

In Kalipso you can define a structure for a local database and when the application is deployed, the database will be automatically created on the device. This type of database is normally used to store temporary information.

The data can be loaded from text files, used and then exported back to text files. Kalipso has actions to automatically export and import data to and from text files. For further information see the “File Import to Table” and “File Export From Table” in the “Actions” chapter.

When you click on add tables the information that appears is that represented in the following window. The window is divided in three tabs: table, Columns and Browse Data.

Tab - Table

Details

• Name - Name for the table

• Database Profile - Not applicable to this profile.

• ODBC Connection - Not applicable to this profile.

• User - Not applicable to this profile.

• Sync. Profile - Not applicable to this profile.

Description

• Text area - Open field for the description of the table. Kalipso does nothing with this information.

Tab - Columns

In this tabulation, the columns of the table created in the previous option are created. The criteria to consider are:

• Column - Name for the column of the table.

• Column Type - Select the type for the column. It can be one of:

  • Varchar

  • Numeric

  • Decimal

  • Date

  • Time

  • DateTime

• Size - Define the size for the column in characters.

• Decimal Places - Define the number of decimal places

• Key? - Check box to indicate which of the available columns is the key.

• Output Mask - Enter the output mask to specify exactly how data should be presented

• Input Mask - Enter the input mask to specify exactly how data should be entered

In the right there are four icons to work with the columns:

• Move up - Moves the selected column up on the list.

• Move down - Moves the selected column up on the list.

• Rename - Rename the selected column.

• Delete - Deletes the selected column.

To add a column just click on the field "column".

Tab - Browse Data

To use this tab you can introduce a script in the first area, click on the refresh icon and you will see the search result in the area immediately below.