The standard functions in system masks are used to create, query and update records. Here you find a survey. Details for the individual standard functions will follow.
After opening system masks are always empty. you have to fill the mosque with records, i.e. trigger a query in the database and load the records found locally into the mask. Refresh will start such a query without search criteria and will load all records found into the mask.
Note!
It is a precondition for searching for all records that no old search terms are entered in the search line (e.g. from a previous query).
Query
Via query you shift the mask into Query mode (Query mode of mask-edit state). his sewage line will appear, where you formulate the query. You can use the -> edit functions. Then you start the query or cancel.
If after a Fetch more than 0 records are found in the database, DataView will only display the first 0 records. Then a message is shown. In this case there are two possibilities:
The record that has been the current record in the mask prior to the search (marked by position indicator in list or displayed in form) will remain current after Fetch if it is part of the query result.
A query consists of search terms. Search terms can be entered in one or several fields of the search line. Search terms in several fields are automatically combined by UND. A search term can contain the following operators and special characters.
Comparison operators (for field types: String, Integer, Float, Money, Date):
Combination operators (for all field types):
Replacement characters (wildcards):
Replacement character | Comment |
% | Replaces no or any number of unknown characters |
? | Replaces exactly any one unknown character |
Expression | Comment |
" (2 single quotation marks) | Query for ZERO values |
'Expression' | Query for an expression containing spaces |
If you do not enter any search terms (empty fields in the search line), DataView will fetch all records (just as standard function Refresh).
Query results can be delivered by the database in a sorted order or they can be sorted locally in the mask after delivering.
In all combined forms the currently displayed sub-list
will also be shifted into query mode after searching in the header form. Search
requests can then be formulated both in the header form and in the sub list.
This allows combined search. For instance, you can search in an item form with
a supplier sublist for an item with a certain supplier.
Insert
With Insert the mask is shifted into Insert mode of Mask-Edit state. A new empty record is prepared for data entry. You can use -> edit functions. After entering data the record can be stored or the function can be cancelled.
Button | Context menu item | Comment |
![]() |
Store | Stores the new record in the database and leaves the Insert mode. |
![]() |
Quit | Cancels the function and leaves the Insert mode without any changes. |
DataView writes all field contents - including invisible fields - without any special layout into a print file and sends them via the Print command to the printer entered in a start procedure dtv_pri
in the server directory < com>
. The print file name is automatically created from the mask name and the path to the server directory < tmp>
.
Update puts the mask into Update mode of Mask-Edit state. The data of the selected record (or several selected records) can be edited. You can use -> edit functions. After manipulating the data the record can be stored or the function can by cancelled.
Button | Context menu item | Comment |
![]() |
Store | Stores the changes in the database and leaves the Update mode. |
![]() |
Quit | Cancels the function and leaves the Update mode without any changes. |
With Copy a selected record (or several selected records) is doubled and the mask is shifted into Insert mode of Mask-Edit state. The doubled record must be edited (at least the entries of the significant fields, e.g. number field) in order to get an unambiguous representation of the records in the database. You can use -> edit functions. After copying and editing the record can be stored or the function can by cancelled.
Button | Context menu item | Comment |
![]() |
Store | Stores the new record in the database and leaves the Insert mode. |
![]() |
Quit | Cancels the function and leaves the Insert mode without any changes. |
With Delete the selected record (or several records) are removed from the mask and put into the trash-basket. The deleting process can be reversed or the record can be finally deleted. In both cases the trash-basket has to be opened.
Note!
When master records are temporarily deleted (i.e. a mask object), DataView will check for existing relations to other system entities (i.e. to field objects). If this is the case, a message will appear asking you to delete the relation records first.
Access
The access form informs you about the owner of a record, about access privileges to the record, about the date of creation and the date of the last change. If you are the owner of the record yourself, you can set the owner, the owner group, the access for the owner, the group and the world in the form. Detailed information about this can be found in
-> the access form.
Record Export
Using this form you can export meta records or an individual mask object locally stored in the mask. DataView will automatically determine all dependent objects, e.g. all field objects connected to the mask, and export them.