The
field data form is used to create and manage all fields. The table fields already
created during model definition are entered and can be modified. Additionally
mask-only-fields without any relation to the database table can be created.
The sub-lists inform about the usage of fields in database tables or masks and
allow the modification of table field or mask field attributes.
Mask Assignment |
Mask Default |
Database Attributes |
Field Name | name of the field |
Type | data type of field |
Format | data format of the field |
Field Title | title of the field in masks |
Description | description of the field |
Check String | check string for checking the field entry |
Default Value | default value of the field for newly created records |
Multilinguality | multilingual flag |
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 |
The field's name identifies it uniquely.
Note! A field that already is represent as an object its name can no longer be changed. To do this, you need to delete the field record and create it again
You can use placeholders to insert mask components into a parent mask.
The name of the component itself (the mask's name) is shown in the menu field.
Type
attribute
master attribute for field (T_FIELD)
type, entry
string
max. no. of characters
6
selection tool
all available field types
multilingual field
no
Note! The data type and the length of a table field or view field that already is assigned on a table respectively on a view you can only change in the Table Field sublist.
The system's default lengths are applied when you leave the field, and you can also use default variables to set your own defaults.
Format
attribute
master attribute for field (T_FIELD)
type, entry
string, entry optional
max. no. of characters
2
selection tool
no
multilingual field
no
Note! It is possible that field content are not visible on flush-right, when a virtual length is defined.
Example:
Type definition in table field relation -> F.4, format definition here -> -3. result is the display xxxxxx.xxxx in the database table and the flush-right display xxxxxx.xxx in masks (last digit not displayed).
Field Title
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 string for 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
Multilinguality
attribute
master attribute for field (T_FIELD)
type, entry
string,display only
max. no. of characters
40
selection tool
no
multilingual field
yes