Technical Documentation > TabEditor > Tables Description to Manage Dynamic Tabs

1 - DESCRIPTION OF THE T_COMPONENT TABLE

This table regroups all the information regarding the definition of a component on a dynamic tab.

A component can either be :

- A column in the browser

- An indexation

- A search criteria

A - FIELDS DECLARATION

T_COMPONENT
Name of the column	Type	Length	Information / Comments
ID_COMPONENT	int	4	Unique Id, non-null
ID_TAB	int	4	Tab Unique Id
ITEM_COLUMN	Varchar	20	Targeted column in T_ITEM
ID_SOFTLANG	int	4	Reference in the T_SOFT_LANG table
TYPE_COMPONENT	int	4	Component type
CRIT_FILTER	varchar	10	Filter applied to search criteria
COMBO_TABLE	varchar	32	Name of the associated table if type = 2 (combobox)
ID_PARENT	int	4	Id of the parent component
IS_INDEX	int	4	>0 if yes
IS_CRIT	int	4	>0 if yes
IS_BROWSE	int	4	>0 if yes

B- INDEX

Index	Type	Columns
I_COMPONENT_PK	ASC	ID_COMPONENT
I_SOFTLANG	ASC	ID_SOFTLANG
I_TAB	ASC	ID_TAB

C - DETAILS ON EACH FIELD

•ID_ COMPONENT

Primary unique key.

•ID_TAB

Index of the tab in T_TAB possessing this component.

•ITEM_COLUMN

Name of the column targeted in T_ITEM

•ID_SOFTLANG

Reference in T_SOFT_LANG, indicating the title of the component.

Warning : The T_SOFT_LANG ID_SOFTWARE field for the dynamic tab components is fixed to 501.

•TYPE_COMPONENT

Type of component :

1 = Edit box

2 = Combo box

3 = Date

4 = Time

5 = Number

6 = Multiline Edit Box*

* Multi-line fields are rich edit control objects that resemble an edit box but can handle text that is formatted. Therefore, users should beware of what type and size of fonts they are using in those fields, as the number of authorized characters** will vary depending on the formatting they have chosen.

** In order to know what is the maximum authorized length that each field can contain, users must refer to the ABC8 database documentation.

•CRIT_FILTER

Filter to apply for some search criteria.

Warning : This field is valid only if

IS_CRIT > 0 and TYPE_COMPONENT = 1 or 2 or 4 or 5

TYPE_COMPONENT	Possible Values
1	‘ = ’ or ‘ LIKE ’ (without the apostrophes !)
2	‘ = ’ or ‘ LIKE ’ (without the apostrophes !)
4	‘ <= ’ or ‘ >= ’ or ‘ = ’ (without the apostrophes !)
5	‘ <= ’ or ‘ >= ’ or ‘ = ’ (without the apostrophes !)

• COMBO_TABLE

Name of the table associated to this component, if this one has a type 2 = Combo box

• ID_PARENT

Index in T_COMPONENT of the parent component.

–1 if no parent.

• IS_INDEX

Indicates if this component is an indexing element.

The components are ordered, based on this field.

• IS_CRIT

Indicates if this component is a search criteria.

The components are ordered, based on this field.

• IS_BROWSE

Indicates if this component is a browser column.

The components are ordered, based on this field.

• REMARKS :

Some rights are associated, to each group of users, for any component.

For now, two rights have been defined :

" Can we update this component ? "

" When copying this element, is a value required for this component ? "

In T_SOFT_LANG this translates to :

ID_GROUP_USER	NAME_GROUP	ID_SOFTWARE	PARAM_TYPE	PARAM_CRIT	PARAM_VALUE
Id_group	Name_group	501	Id_component in string of characters	UPDATABLE	" Yes " or " No "
Id_group	Name_group	501	Id_component in string of characters	REQUIRED	" Yes " or " No "

Modifying components of a dynamic tab

Modifying components of a dynamic tab