Field Assignment

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

Field Name

Name of a field displayed in the mask

attribute master attribute for field (T_FIELD)
type, entry string, no special characters, entry required
max. no. of characters 50
selection tool recursive widget (list with existing fields)
multilingual field no

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.


Fields

Syntax:

TABLENAME.COLUMNNAME
for table fields

COLUMNNAME (no period)
only for mask fields


Mask placeholder

You can use placeholders to insert mask components into a parent mask.

Syntax:

@MASKNAME

The name of the component itself (the mask's name) is shown in the menu field.


Sequence

A field's numerical position in the mask

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

Sort type, for queries to the 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

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.

Entry:

n
numerical or alphabetical sort in ascending order

-n
numerical or alphabetical sort in descending order

0
no sort

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

A field's vertical position in a form

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

A field's horizontal position in a form

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

Only for forms, the visible length for fields or focus length for check-boxes, in rows

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

Visible column width of a field or, in forms, the focus width of a check-box

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)

A field's virtual width in a mask

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).

Entry:

0
virtual width not explicitly defined

n
virtual width (max. characters) explicitly defined

More information: -> Field size

Access (access flag)

Access privileges to edit a mask field

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).

Entry:

m
mandatory -> data must be entered for the record to be saved

w
write -> data is optional (default)

r
read only-> field is visible but cannot be modified

(empty)
invisible field -> the field and its contents are not displayed

*
action-specific access -> must be defined in the Insert, Update and Query fields

More information: -> Field access

Insert Access (access flag)

Access privileges for Insert mode

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).

Entry:

m
mandatory -> data must be entered for the record to be saved

w
write -> data is optional (default)

r
read only-> field is visible but cannot be modified

More information: -> Field access

Update Access (access flag)

Access privileges for Update mode

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.

Entry:

m
mandatory -> data must be entered for the record to be saved

w
write -> data is optional (default)

r
read only-> field is visible but cannot be modified

More information: -> Field access

Query Access

Access privileges for Query mode

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.

Entry:

m
mandatory -> data must be entered for the record to be saved

w
write -> data is optional (default)

r
read only-> field is visible but cannot be modified

More information: -> Field access

Video

A field's foreground and background colors

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry two-digit integer, entry required
max. no. of characters 2
selection tool menu containing all video settings, colors are displayed
multilingual field no

This determines the field's color in the current mask. Colors can also be assigned globally using the Client Settings tool.

Entry:

first digit (0 ... 5)
foreground (field entry) color

second digit (0 ... 5)
background color

More information: -> Color settings for fields and field titles

Appearance

Appearance of a field entry displayed in a mask (only for Java Client!)

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

The following restrictions apply for the column "Appearance":

Menu

Name of a field's selection tool or mask component

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 20
selection tool menu with existing menus and button areas
multilingual field no
hyperlink opens the object in an own form, not useful for mask components


Selection tool

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.

Entry:

a menu name (type C = choice-box)

a mask name (type W = modal window)
L>mask name or mask name alone (output as list)
F>mask name (output as form)
no mask name (default list)

a radio button group's name (type B = radio buttons)

More information: -> Selection tools for fields


Mask component

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 of a field's selection tool

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, no special characters, entry optional
max. no. of characters 1
selection tool menu with all selection tool types
multilingual field no

The type and name of the tool you attach to a field must match.

Entry:

C = choice-box
Adds a choice-box directly below the field. It can be opened with the pop-up arrow by the field. The choice-box is scrollable if the length of the menu is set below the number of menu items. (Menu Data form, Max. Length field)

W = modal window
Attaches a modal window to the field, which can be opened using the double arrow button by the field. The window's mask is opened in Search mode.

B = radio button group
If used in a form, the field is replaced by a radio button group. When the field is entered, the button group is highlighted, and one of the radio buttons can then be selected. The button's text is then entered into the field.

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

Name of a userexit on the Pre_Field trigger

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 2000
selection tool menu with all field userexit functions (separated for system- and user-library)
multilingual field no

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

Name of a userexit on the Post_Field trigger

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 2000
selection tool menu with all field userexit- functions (separated for system- and user-library)
multilingual field no

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

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 2000
selection tool menu with all field userexit- functions (separated for system- and user-library)
multilingual field no

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

Opens the Mask Data form, if the record contains a mask component.

If a mask component exists as a field name, the corresponding form for editing it is opened.

Form

Opens the record's Field Data form.

Mask Assignment

Opens the Mask Assignment form and shows the masks where a field is displayed.