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)
| ?%
|