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
