The sub-list is used to create and manage all relation attribute fields of the relation displayed in the header form. After storing the table field records not only the table field relations but also the field objects have been created (-> field data form). Thus the fields are also available to be used in masks.
Field Name | name of the table field |
Sequence | position number of the field in the table |
Data Type | data type and length of the table field |
Index 1-3 | field index |
Uniqueness 1 | uniqueness flag |
Multilinguality | multilinguality |
Mode | query mode |
Non Null | non-zero flag |
Field Title | title of the field in masks |
Description | description of the field |
Check String | string for checking field entries |
Default Value | field default for newly-created record. |
Form | opens selected record in the form |
Mask Assignment | shows the usage of the field in masks |
attribute | master attribute for field (T_FIELD) |
type, entry | string, no special characters, specification required |
max. no. of characters | 50 |
selection tool | no |
multilingual field | no |
When you create a new field, the TABELLENNAME from the header is inserted automatically. You only need to add the COLUMNNAME.
Note!
Once the database table or view has been created and the field (if new) exists as an object, its name can no longer be changed. To do this, you need to delete the field record, create it again, and then recreate or modify the table or view.
Sequence
attribute
master attribut for field (T_FIELD)
type, entry
integer, entry required
max. no. of characters
5
selection tool
no
multilingual field
no
The numerical position of a field determines the sequence of fields in the database table.
DataView needs the numerical position to determine the field order when creating default masks. This sequence has no meaning within the database table or view itself.
Type
attribute
master attribute for field (T_FIELD)
type, entry
string, no special characters, entry required
max. no. of characters
6
selection tool
menu with all data types
multilingual field
no
The system's default lengths are applied when you leave the field, and you can also use default variables to set your own defaults.
Index 1-3
attribute
master attribut field (T_FIELD)
type, entry
string, no special characters, entry optional
max. no. of characters
13
selection tool
no
multilingual field
no
Using indices makes looking up the field in the database faster. Looking up several fields can be speeded up by assigning all the fields the same index.
Multilingual fields cannot be indexed.
More information:
-> Indexed fields
Uniqueness 1-3
attribute
master attribute for field (T_FIELD)
type, entry
string, entry required
max. no. of characters
1
selection tool
menu with all uniqueness flags for master tables
multilingual field
no
If the flag is set, DataView saves the field's contents as unique, which means that every record in the table is identified uniquely. If you use the field in masks, altering the data in an existing field will generate an error message.
You should flag fields as unique whenever they are responsible for uniquely identifying records, in particular:
Only indexed fields can be unique.
More information:
-> Unique fields
Multilinguality
attribute
master attribute for field (T_FIELD)
type, entry
string, entry required
max. no. of characters
40
selection tool
menu with all available languages
multilingual field
yes
You can define the languages supported by each multilingual field. The languages field holds a comma-separated list of language keys. Using the menu, you can either select the entire default language list or select one or more language keys individually. When DataView generates the table or view, it also creates the appropriate number of field objects internally, to hold text in various languages. These internal field names are always formed by adding a language key as suffix, e.g. TABLENAME.COLUMNNAME_LNG.
Multilingual fields cannot be indexed.
More information:
-> Language management
Mode
attribute
master attribute for field (T_FIELD)
type, entry
string
max. no. of characters
1
selection tool
menu with all search modes
multilingual field
no
If a field's case sensitivity is defined, the case sensitivity set in the default variable QUERYMODE is ignored for that field.
Non Zero (NN)
attribute
master attribute field (T_FIELD)
type, entry
logical
max. no. of characters
1
selection tool
no
multilingual field
no
Of the flag is set to Non-Zero, it must hold an entry in the database table. If the field is used in a mask, an entry is forced by setting the field's Access for the mask's Edit Mode to m = mandatory.
The Non-Zero flag should be set for every field which provides a record's unique ID, in particular:
attribute | master attribute for field (T_FIELD) |
type, entry | string, entry optional |
max. no. of characters | 50 |
selection tool | no |
multilingual field | yes |
Field titles are crucial in integrating graphics and images into forms.
In lists, the title is a field's column label, displayed in the lists header. In forms, the title can be positioned anywhere relative to the field.
More information: -> Field titles
When you use this field in forms, you can insert a graphic or image as a label and use it to help design the form.
Entry for the type of graphic:
You can also set the stroke width of a line or outline.
Example: for a raised rectangle, enter @RECT2BUMP
More information: -> Graphics and images in forms
An image is displayed in place of the field title.
More information:
-> Graphics and images in forms
Description
attribute
master attribute for field (T_FIELD)
type, entry
string, entry optional
max. no. of characters
50
selection tool
no
multilingual field
yes
When users are editing a record and the cursor enters a field, its verbose description appears in the mask's footer. You should use the description to characterized the field in more detail or warn of potential invalid data.
Check String
attribute
master attribute for field (T_FIELD)
type, entry
string, entry optional
max. no. of characters
50
selection tool
no
multilingual field
no
You can use check strings to check the syntax of the data entered into a field, e.g. whether an article number complies with certain conventions. Check strings consist of a series of check characters.
Attention! The check string may not contain spaces followed by further check characters.
More information:
-> Check range of values of field entries
Default Value
attribute
master attribute for field (T_FIELD)
type, entry
string, entry optional
max. no. of characters
50
selection tool
no
multilingual field
no
If the field is used in a mask, DataView automatically enters the default whenever a user creates a new record. The user may or may not be able to alter the default, depending on the field's access status.
More information:
-> Automatically filling fields
Form
Mask Assignment (menu only)