|
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 Updated on Thursday, 01 October 2009 14:47 |