The table is composed from a set of columns, each column define data type and check rule on insert data.
An important feature is to define constraint between tables. Those constraint are obtained via TableRelation, so when we operate on data from a table we have available also the data of related table.
Column property are:

Name
Column Name

DataType
Data Type (see below table).

Size1
Dimension 1 for data type (see below table).

Size2
Dimensione 2 for data type (see below table).

AllowNulls
If column admit null values

ReadOnly
For a read only column

DefaultValue
Default value for a new record.

AutoIncrementStep
If > 0 the column is a automatic progressive number and this field indicate the progressive step to apply for each record. It can be applied only for NUMERIC column.

AutoIncrementStart
The Start Value for progressive number. It can be applied only for NUMERIC column.

TableRelation
It create a Table relation N --> 1. Syntax to use:

<Package>.<Table>.<Column>

In case of relation of more column:

<Package>.<Table>.<Column>[Col1=ColTabRel1 && ... && ColN=ColTabRelM]
where:
ColX is a Table column
ColTabRelY is a column of related table.

TableRelationCondition
It is valid only if “TableRelation” is used
A condition to apply to data in relate table, it force data entry and validate them..

TableRelationLayoutSettingEnabled
It is valid only if “TableRelation” is used
If enabled it do not consider default way of work for related table, but apply the defined one

TableRelationViews
It is valid only if “TableRelationLayoutSettingEnabled” is used
List of View for related table

TableRelationDefaultView
It is valid only if “TableRelationLayoutSettingEnabled” is enabled
Default View for relate table.

TableRelationAlwaysFilterUse
It is valid only if “TableRelationLayoutSettingEnabled” is used
before user acces to View data, it apply a filter..

TableRelationDefaultForm
It is valid only if “TableRelationLayoutSettingEnabled” is used
Default Form for show data of relate table.

RapidSelectionColumn e RapidSelectionCondition
This nice feature can be useful for perform “Rapid selection”.
Those property permit to perform rapid selection on column relate to  TableRelation property.
Whit those property the number of action to search data are reduced . RapidSelectionColumn its column where  TableRelation is defined  RapidSelectionCondition its filter on table.
In search criteria we can use jolly char like ?.

DataFormat
How to format data for final user (see below table). Syntax:

<type>:<pattern>

Trim
due its value it is an indication if delete space in begin and end of the column data. Valido if DataType is CHAR or RESLANG_CHAR.
Possible values:

NONE: do not delete.
BEFORE: delete space at string begin.
AFTER: delete space at string end. (Default)
BEFORE_AND_AFTER: delete on both side.

UseDefaultLocaleIfNull
This property is used for column with RESLANG_* DataType. If Enabled apply default language where language value is null.

Label
Label (in language) to show to user when there is a reference to column.

ColumnVisible
If column must be visible on list.

ColumnWidth
Width of column on list.

Expression
Expression in order to set column value.
Into expression can be used table values or column from relate table via:

<ColumnRel>.<TableRelColumn>

Where:
<ColumnRel> is name of column where  TableRelation property is set mentre 
<TableRelColumn> is a column name of relate table.
If table have got sub-table we also can apply expression on them like sum for a specific column field. Syntax:

<Oper>@<SubTable>.<SubTableColumn>

Where:
<Oper> is operaion name to execute on rows
<SubTable> if name of subTable
<SubTableColumn> name of a column from subTable.
Expression property is valid if column DataType is either: NUMERIC, DOUBLE, CHAR, DATETIME o BOOLEAN, also Expression value must be the same type of column where expression is set to.
The DataType can be set to calculate also, in this case the expression result is not stored on table. Calculated cannot be used for exopression on subtable.

 

Allow Values

In case into a column it is required to fix predefined values, we can set the rows of “Allow Values” Each rows have got those property:

Value
Values the column can be set to. Must be same type of column.

Label
Label (language based) to show to user when the column is refered.

 

 

TABLE – Data type

DataType

Size1

Size2

Descrizione

NUMERIC

1 - 18

1 - 18

Numeric: Decimal. Size1 = number of digit before “comma”; Size2 = number of digit after “comma”.

DOUBLE

No

No

Numeric: real

CHAR

1 - 4000

No

String. Size1 = characters number

DATETIME

0 = DMYhms

1 = DMY

2 = hms

10 = D

11 = M

12 = Y

13 = DM

14 = MY

20 = h

21 = m

22 = s

23 = hm

24 = ms

No

DateTima

BOOLEAN

No

No

Boolean / Sì-No

BINARY

No

No

Array of byte

TEXT

No

No

Text without limit dimension

IMAGE

No

No

Immage

AUDIO

No

No

Audio

VIDEO

No

No

Video

RESLANG_NUMERIC

LIKE NUMERIC

like NUMERIC

like NUMERIC with language management

DOUBLE

like DOUBLE

like DOUBLE

like DOUBLE with language management

RESLANG_CHAR

like CHAR

like CHAR

like CHAR with language management

RESLANG_DATETIME

like DATETIME

like DATETIME

like DATETIME with language management

RESLANG_BOOLEAN

like BOOLEAN

like BOOLEAN

like BOOLEAN with language management

RESLANG_BINARY

like BINARY

like BINARY

like BINARY with language management

RESLANG_TEXT

like TEXT

like TEXT

like TEXT cwith language management

RESLANG_IMAGE

like IMAGE

like IMAGE

like IMAGE with language management

RESLANG_AUDIO

like AUDIO

like AUDIO

like AUDIO with language management

RESLANG_VIDEO

like VIDEO

like VIDEO

like VIDEO with language management

CALCULATED

No

No

like CALCULATED (not stored on DB).

 

TABLE – Data format

Type

Pattern

Description

DateTime

Vedi java.text.SimpleDateFormat di java

Datetime format

Number

Vedi java.text.NumberFormat di java

Numeric format

Last updatedMonday, 29 November 2010 09:56