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.
Last updated