Table Fields

The sub-list is used to create and manage all type attribute fields of the type relation displayed in the header form. After storing the table field records not only the table field relations but also the field objects are created. 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
Type data type and length of the table field
Index 1-§ field index
Uniqueness 1-3 uniqueness flag
Languages languages
Mode search 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 marked record in an own form
Mask Assignment displays the usage of the field in masks

Field Name

Name of the table field

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

Syntax:

TABLENAME.COLUMNNAME

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

Position number of the field in the table

attribute master attribute 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 or view.

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

Data type and length of the table field

attribute master attribut 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

Syntax:

TYPE and LENGTH, without a separating space, e.g. S

Entry:

B -> Binary
BLOB (Binary Large Object) field. This type of field can hold binary data directly, and its length need not (cannot) be defined a priori.

More information: -> BLOB fields

C -> Calculation
Calculation field. These fields display database independent information in masks, and are only considered when the model object creates its default masks.

More information: -> Calculation fields

D -> Date
Date fields can hold dates and times, e.g. .. ::. The date format (nationality) for masks can be set using the default variable DATEFORMAT, and the database format depends on the attached database itself. The field length cannot be predetermined (although the internal default is bytes).

More information: -> Date fields

F -> Real
Real fields hold fixed-point decimal numbers, e.g. 0. or -0.. The default is F.3 ( = places before the point, 3 = places after the point), and the data can also be displayed exponentially, e.g. 3.e-2. You can enter data using a decimal point or comma, and this will be auto-corrected.

I -> Integer
E.g. 0 oder -0. The default is I.

L -> Logical
Field of the Boolean type. It can only take the values ON, OFF or EMPTY. No length specification is possible.

M -> Money
Money fields hold values as currency, e.g. $0.. The default is M,2 ( = places before the point, 2 = places after the point). You can enter data using a decimal point or comma, and this will be auto-corrected.

S -> String
You can enter text into string fields in 8-Bit ASCII format. The default is S. String fields longer than 255 characters are defined as longtext fields.

More information: -> Longtext fields

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

Index for table field

attribute master attribut for 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.

Syntax:

TABLENAME_INDEXNAME

Multilingual fields cannot be indexed.

More information: -> Indexed fields

Uniqueness 1-3

Uniqueness flag

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:

Entry:

G -> globally unique
All records in the type table are unique

2 -> Id-2 unique
partial uniquess for all type`s record with the same parent element (unique field C_ID2 represent a combined key)

- -> not unique (default)

Only indexed fields can be unique.

More information: -> Unique fields

Languages

Language list for table or view fields

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.

Syntax:

LNG1, LNG2, ..., LNGn

Multilingual fields cannot be indexed.

More information: -> Language management

Mode

Search mode for a table field

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

Entry:

(empty)
no case sensitivity (default)

I -> insensitive
alphabetical case is ignored

S -> sensitive
alphabetical case is considered

If a field's case sensitivity is defined, the case sensitivity set in the default variable QUERYMODE is ignored for that field.

Non-Null (NN)

Non-Null flag

attribute master attribut for field (T_FIELD)
type, entry logical
max. no. of characters 1
selection tool no
multilingual field no

Of the flag is set to Non-Null, 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:

Entry:

Not set (default)
a NULL entry is possible

Set
an entry is forced (field's Access is m = mandatory)

Field Title

A field`s title in masks

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.


Field Titles

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 title


Graphics (forms only)

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:

@RECT
creates a rectangle

@CIRC
creates an ellipse

@LINE
creates a line

You can also set the stroke width of a line or outline.

Entry for the border style:

SOLID
simple lines

BUMP
3D embossed

HOLE
3D engraved

DITCH
edge only engraved

RIDGE
edge only embossed

Example: for a raised rectangle, enter @RECT2BUMP

More information: -> Graphics and images in forms


Images (forms only)

An image is displayed in place of the field title.

Syntax:

#filename

More information: -> Graphics and images in forms

Description

Verbose description of a field

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

String for validating data entered into a field

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.

Check characters:

0
The character entered will be changed into a space character. If the position is pre-assigned by a character (Default value), this character is fixed to the position. If the pre-assigned value is shorter than the check pattern, a space character will be entered.

a
Capitals automatically changed to lower case, any character permitted.

A
Lower case automatically capitalized, any character permitted.

I
Capitals automatically changed to lower case, no special characters.

L
Lower case automatically capitalized, no special characters.

N
Only numerical characters.

X
X represents any fixed character. Any character entered will be automatically changed into the fixed character specified here. This process is case-sensitive, irrespective of whether the user presses the Shift key or not. Special characters are allowed.
With \X the meaning of check characters cease. They become regular characters and can be used as fixed characters.

>[check character]
Placing > in front of a check character requires that every character after the position of the check character complies with the check character. The check character ">0" (even as a sub-string) is illegal.

Attention! The check string may not contain spaces followed by further check characters.

More information: -> Check range of values of field entries

Default Value

Provides a field with a default value for when a record is created.

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.

Entry:

@DEFAULT
references a variable in the Default Data list. DataView writes the variable's value into the field, allowing it to be set independently of the user

@USER
enters the current user into the field

@GROUP
enters the current group into the field

@TODAY
enters the current date into the field - which must be of type DATE

Filename
Default graphic file for BLOB fields. This is the graphic displayed in forms if the database BLOB field is empty. The default graphic file must be stored in a folder on the server. The path may also be given.

More information: -> Automatically filling fields

Form

Opens the Field Data form for the marked record.

Mask Assignment

Opens the Mask Assignment form, which shows a table field's usage (display) within masks.