Here you can select fields to display in the current mask. You can choose any existing table or view fields, independent calculation fields or placeholders, which reference mask components. You can assign mask-specific field attributes for each field. You may not modify field assignments in existing default masks, as these are required internally by DataView.
Field Name | name of a field displayed in the mask |
Sequence | a field's numerical position in the mask |
Sorting | sort type, for queries to the field |
Row | a field's vertical position in a form |
Column | a field's horizontal position in a form |
Length | visible field length or check-box focus length in rows |
Width | visible field width or check-box focus width
in columns |
VWidth | virtual (visible and invisible) width |
Access | access privileges to edit a mask field |
Insert Access | access privileges when using the clipboard |
Update Access | access privileges when updating |
Query Access | access privileges for Search |
Video | a field's colors |
Appearance | appearance of a field entry displayed in a mask |
Menu | name of a field's selection tool or mask component |
Type | the type of a field's selection tool |
Pre-Field Userexit | name of a userexit on the Pre_Field trigger |
Post-Field Userexit | name of a userexit on the Post_Field trigger |
Hyper-Field Userexit | a hyper-field trigger |
Shift | opens the Mask Data form for a mask component |
Form | opens the record's Field Data form |
Mask Assignment | displays a field's usage in masks |
The field's name identifies it uniquely within the mask-field relationship. You can only enter (or select) the names of existing fields.
Attention! Mask-field assignments in default masks may not be modified. If a default mask is to be used as a template, its record must first be copied into the Mask Data header form. Assignment can then be modified in the copy.
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.
attribute | relation attribute for mask-field (T_MAS_FLD) |
type, entry | Integer, entry required |
max. no. of characters | 5 |
selection tool | no |
multilingual field | no |
A field's numerical position is also its logical position.
In lists, the fields appear in their logical order, in forms they can be placed arbitrarily.
Sorting
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
Integer, entry required
max. no. of characters
5
selection tool
no
multilingual field
no
The Sort type determines the order of the records returned after a query DataView sorts fields of type integer, real and money numerically, and string fields alphabetically.
n determines the field's priority when sorting by more than one field. 1 has the highest priority.
Example: Field A: n = 1, Field B: n = -2 -> DataView sorts the records according to field A in ascending order. If there is more than one record where field A is identical, DataView sorts these records according to field B in descending order.
Note! Non-zero sort types can take a long time. For imprecise queries in particular, which yield a large number of records (> 0) as a result, you should rely on local sorting.
Note!
There is a Sort Mask, where users can alter the sort type before a query. It can be opened for the active field with [Strg+O]. The setting overwrites the value in the Mask-Field relationship until the mask is closed.
Row
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
Integer, entry required
max. no. of characters
5
selection tool
no
multilingual field
no
DataView ignores the entry for lists and fields.
For mask components in forms, the position is given by the value entered here plus the component's position.
More information:
-> Field order and position
Column
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
Integer, entry required
max. no. of characters
5
selection tool
no
multilingual field
no
DataView ignores the entry for lists and fields.
For mask components in forms, the position is given by the value entered here plus the component's position.
More information:
-> Field order and position
Length
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
Integer, entry required
max. no. of characters
5
selection tool
no
multilingual field
no
For lists, the length is always automatically 1, for forms, the value can be arbitrary, so that fields can occupy more than one line. The product of the length and the visible width provides the total visible size.
Attention! The total visible length may not exceed 255 characters (with the exception of BLOB- and calculation fields).
More information:
-> Field size,
-> Displaying logical fields
Width
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
Integer, entry required
max. no. of characters
5
selection tool
no
multilingual field
no
The value is the visible width actually displayed in the mask. The product of the length and the visible width provides the total visible size.
Attention! The total visible length may not exceed 255 characters (with the exception of BLOB- and calculation fields). Single-column lists must have a width of at least 5, otherwise they will not display properly.
More information:
-> Field size,
-> Displaying logical fields
V-Width (virtual width)
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
Integer, entry required
max. no. of characters
5
selection tool
no
multilingual field
no
The virtual width determines the maximum number of characters it can accept, and could therefore be termed the total virtual size of a field. It is always useful to set the total virtual size to more than the total size (length x width), if you want to display the field in abbreviated form, e.g. when the mask becomes full. Set Virtual Width = 0 to define no virtual width explicitly, i.e. total visible size = total virtual size.
For longtext fields you need to enter a virtual size of over 255 (generally ), for BLOB fields the value is irrelevant (usually set to 0).
More information:
-> Field size
Access (access flag)
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
string, entry optional
max. no. of characters
1
selection tool
menu with all access Ids
multilingual field
no
Field access determines how a user may edit a field's record. Access privileges apply to all editing, i.e. any of the standard functions Insert, Copy, Edit or Search.
If you want to define different privileges for Insert, Update and Query, you need to use action-specific access flags (Insert, Update and Query fields).
More information:
-> Field access
Insert Access (access flag)
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
string, entry optional
max. no. of characters
1
selection tool
menu with all access Ids
multilingual field
no
Insert Access determines a user's access privileges for Insert mode (Copy and Paste).
More information:
-> Field access
Update Access (access flag)
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
string, entry optional
max. no. of characters
1
selection tool
menu with all access Ids
multilingual field
no
Update Access determines a user's access privileges after selecting Edit.
More information:
-> Field access
Query Access
attribute
relation attribute for mask-field (T_MAS_FLD)
type, entry
string, entry optional
max. no. of characters
1
selection tool
menu with all access-settings
multilingual field
no
Query Access determines a user's access privileges after selecting Search.
More information:
-> Field access
Video
This determines the field's color in the current mask. Colors can also be assigned globally using the Client Settings tool.
More information:
-> Color settings for fields and field titles
Appearance
Icon | displays an icon |
Icon & Text | displays either an icon, only text, or an icon with text |
Tree Renderer | displays the values of the column as a tree |
Tree Structure | evaluates the values of the column as hierarchy levels |
A selection tool is linked to the field. The tool is available while the user is editing the field. The selection tool's name depends on the type of tool.
More information: -> Selection tools for fields
You can only enter the name of a mask (component) if the field is a placeholder (Syntax: @MASKNAME in fieldname). The mask component is then placed in its parent mask. You'll only want to place form components into a parent form or list components into a parent list.
More information:
-> Mask components
Type (menu type)
The type and name of the tool you attach to a field must match.
Note! Field selection tools of type M (menu) and L (List box) from DataView versions prior to 4.1 are automatically displayed as choice-boxes from version 4.1 onwards. The old M or L entries are retained, but are no longer supported in new records.
More information:
-> Selection tools for fields
Pre-Field Userexit
The Pre_Field userexit is executed before a field is entered in an Edit state (only for Update and Insert modes, not Query or View).
Post-Field Userexit
The Post_Field userexit is executed before a field is entered in an Edit state (only for Update and Insert modes, not Query or View).
Hyper-Field Userexit
A hyper-field trigger enables functions to be executed by a simple mouseclick. If a Hyper_Field userexit is installed and the field is not empty, the field content will be displayed as underlined when the mouse pointer moves over it. The mouse pointer changes. A mouse click will then trigger the action.
Hyper_Field userexits are especially useful for default menu userexits (which are not available in the selection menu).
Shift
If a mask component exists as a field name, the corresponding form for editing it is opened.
Form
Mask Assignment