List of System Default Variables

When DataView is installed, the following default variables have values for the user SYSTEM. You cannot delete the system-default records. They are automatically also valid in the application. If you want to assign a different value to a system default value in your application, this can only be done using a copy of the record for another user (e.g. user GLOBAL = all users). The original default value will then not be available to the user in the application.

System Variable Comment Default Value
BLOBSIZE Maximum size of BLOBs in byte.
The minimum size cannot be defined to be smaller than KB.
0
DATEFORMAT Default format for fields of the type date in masks (mask date format), separated for the possible languages English (..._ENG), French (..._FRA), German (..._GER), Spanish (..._ESP), Japanese (..._JAP) or one of the freely definable langauges (..._LN1 to ..._LN5):
D -> day, two-digit
M -> month, two-digit
A -> month, as text for DATEFORMAT_ENG
Y -> year, two-digit or four-digit
H -> hour, two-digit
M -> minute, two-digit
S -> second, two-digit
All six numeral values for day, month, year, hour, minute, and second must exist. Any single character (but no digit) can be used as delimiter. First the day, month and year must be specified in any sequence followed by hour, minute, and second in any sequence.
If the format definition for _ESP, _JAP or _LN1 ... _LN5 is missing, the value of the current system language is used.
ENG:
M/D/Y H:M:S
FRA:
D.M.Y H:M:S
GER:
D.M.Y H:M:S
DISPNOACC Defines the display of records in masks for which the current user has no read privilege:
ON -> records displayed as dotted line)
OFF -> records not displayed
ON
DISPNOACCSEL Transfers access limitations for selection-forming records to field selection menus (while automatically creating selection texts from entries of a database table using the macro @TABLENAME.COLUMN1,COLUMN2,...):
ON -> access definition in the source table are taken into consideration. Only the selection texts the current user has (at least) read access to are visible and selectable.
OFF -> access definition the source table are not taken into consideration. All selection texts are visible and can be taken from the selection menu into the field.
OFF
DTV_CRS_FET_SIZ Server performance optimization. Sets the block size for getting data from the database (fetchblock size). 50
DTV_FLD_MAP_QRY Server performance optimization. Sets the method for access to fields in masks:
0 = combined lists (old procedure)
1 = MAP-mechanism
>= 2 = Hashmap mechanism
if epshr.dll exists -> 2
otherwise -> 1
DTV_MEN_CRE_ALG Server performance optimization. Sets the algorithm to generate menus/button-areas:
0 = recursive algorithm (old procedure)
1 = structure resolution for TOP menu only
2 = structure resolution for context menus only
3 = structure resolution for all menus
3
DTV-PWD-... cf. variables for controlling ->Enhanced Security -
ELMACC Access Id entered by default when new records are created in tables:
> < -> no privilege
r -> read privilege
w -> write privilege
d -> delete privilege
The value must consist of three characters describing the access privilege in the sequence owner, group, and world.
dwr
ENTACC Access Id entered by default when new entities and relations are created:
> < -> no privilege
r -> read privilege
w -> write privilege
d -> delete privilege
The value must consist of three characters describing the access privilege in the sequence owner, group, and world.
dd_
FLOAT Standard format for table fields of the type REAL/FLOAT. The value must start with the letter F. Then the values for the total number of digits and the number of decimal digits follow, separated by a point. F.3
INTEGER Standard value for table fields of the type INTEGER. The value must start with the letter I. Then the value for the number of digits follows. I
KEYBOARD Language of the keyboard used:
GER -> German
ENG -> English
FRA -> French
GER
LANGUAGE_DEFAULT Default language at DataView program start:
LNG -> language shortcut from LANGUAGE_LIST
GER
LANGUAGE_LIST Registers the languages required in the application as a comma-separated list of a maximum of language shortcuts: GER -> German
ENG -> English
FRA -> French
ESP -> Spanish
JAP -> Japanese
LN1 ... LN5 -> freely configurable languages
GER, ENG, FRA
LANGUAGE_SYSTEM System language at DataView program start:
LNG -> language shortcut from LANGUAGE_LIST,
If a comma-separated list of language shortcuts is passed instead of a language shortcut, the corresponding language selection box will not display all languages any longer, but only the languages contained in the list. The first language shortcut will still determine the system language.
GER, ENG
LANGUAGE_USERDATA User data language at program start of DataView:
LNG -> language shortcut from LANGUAGE_LIST,
If a comma-separated list of language shortcuts is passed instead of a language shortcut, the corresponding language selection box will not display all languages any longer, but only the languages contained in the list. The first language shortcut will still determine the user data language.
GER
LOADER Select the table loader:
ASCII -> ASCII loader)
BLD -> Binary loader
In case of modifications of tables with the help of the function creates table/view in the model object forms, the binary loader will always be used irrespective of the settings.
ASCII
MENUSYSTEM Activates or deactivates the display of manager toolbars and manager menus for users with manager privileges:
ON -> manager toolbars/menu displayed/active
OFF -> manager toolbars/menu not displayed/active
ON
MONEY Standard format for table fields of the type MONEY. The value must start with the letter M, followed by the values for the total number of digits and the number of digits after the decimal point. Both numbers are separated by a point. M.2
QUERYAND Standard value for the AND operator and for data queries in a mask.
The entry can be a sequence of any characters, but the first character must not be the standard character &. Regardless of the definition you specify here you can always use the standard character &.
&
QUERYGREATER Standard value for the comparison operator GREATER for data queries in a mask.
The entry can be a sequence of any characters, but the first character must not be the standard character >. Regardless of the definition you specify here you can always use the standard character>.
>
QUERYLESS Standard value for the comparison operator LESS for data queries in a mask.
The entry can be a sequence of any characters, but the first character must not be the standard character <.. Regardless of the definition you specify here you can always use the standard character<..
<
QUERYMODE Kind of the case-sensitivity for search requests for data queries in a mask:
MIXED -> If no replacement character is in the search term, then SENSITIVE, else INSENSITIVE (default value)
SENSITIVE -> uppercase/lowercase considered, search like input
INSENSITIVE -> uppercase/lowercase ignored (low performance)
If field-specific case sensitivities have been defined (Mode Field in the field assignment table), the case sensitivity defined here will be overridden for the corresponding fields.
INSENSITIVE
QUERYNOT Standard value for the comparison operator NOT for data queries in a mask.
The entry can be a sequence of any characters, but the first character must not be the standard character !. Regardless of the definition you specify here you can always use the standard character !.
!
QUERYOR Standard value for the OR operator and for data queries in a mask.
The entry can be a sequence of any characters, but the first character must not be the standard character |. Regardless of the definition you specify here you can always use the standard character |.
|
QUERYSIZE Maximum length of search terms for data queries in a mask (maximum 255). 0
RELATIONLOCK Controls the locking for parent and child elements when relations are created:
ON -> locking on
OFF -> locking off
ON
REPLACEMODE Allows or prohibits the exchange of child elements in update mode of mask edit state in relation masks.
ON -> exchange allowed
OFF -> exchange prohibited
The variable only controls the behavior in application-specific masks; in DTV system masks child records can always be exchanged.
OFF
STRING Standard value for table fields of the type string. The value must start with the letter S followed by the value for the length. S
TOPBUTTON Name of the button area to be used as default icon bar (top button area). TOP_BUT
TOPMENU Name of the menu to be used as top menu. TOP
USXINIT Name of the initialization userexit.
The userexit is automatically executed when DataView is started. It allows data-driven initialization of user functions. Frequently masks, for instance, could be opened right after system start.
INIT
VERSION Current DataView version number. DTV4.1-??
VIDEOEDIT Global color representation for field titles in Insert or Update mode of Mask-Edit state.
First digit 0 ... 5 -> Color of the title text
Second digit 0 ... 5 -> Color of the title background
OFF -> no special title color in mask-edit state
OFF
VIDEOHYPERLINK Global colour representation for hyperlink fields.
First digit 0 ... 5 -> colour of the field contents
Second digit 0 ... 5 -> colour of the field background
OFF -> No special field color for hyperlink field
OFF
VIDEOMANDATORY Global color representation for field titles of mandatory fields in Insert or Update mode of Mask Edit state.
First digit 0 ... 5 -> Color of the title text
Second digit 0 ... 5 -> Color of the title background
OFF -> no special title color in mask-edit state
A state independent title color set in the field V-Tit (-> mask-field relation) for individual mandatory fields is changed for mask-edit state.
OFF
WILDCARD Single- and multi-character wildcard for search queries:
First character -> single character wildcard (replacement for exactly 1 unknown character)
Second character-> multi character wildcard (replacement for none or any number of unknown characters)
?%