programmable relational database
with graphical user interface
Below documentation is part of the MUIbase dictribution and is also available in PDF.
In this chapter you find:
8.1 Log Table
For logging changes to a project, MUIbase uses an internal table named `_Log'. Note the underscore as the first character which indicates that this table is a system table managed by MUIbase that cannot be changed. The table contains the following attributes which are all of type string:
The `_Log' table can be accessed like any other table of a project. For example, a select-from-where query
8.2 Activate Logging
By default, logging is not enabled in a project. In order to start logging changes, select menu item `Log - Logging active'. The state of this menu item is stored in the project file, thus, once activated and saved, changes will be kept logging when re-opening the project. De-activate the menu item to stop logging changes.
Note that only for those tables and attributes, that have the `Log changes' property set, will changes be logged (see Creating tables and Creating attributes). The changes that are logged are adding a new record, deleting a record, or changing a field in a record. For each such action, a new log entry is created and added to the `_Log' table.
8.3 Set Log Label
The `_Log' table has an attribute named `_Label' that can be freely set by the project. Choosing menu item `Log - Set log label' opens a dialog for entering the label text.
It is also possible to provide the label through a program function.
The function should have the name
Note that when the function
8.4 Import Log
It is possible to import log entries from an external file. This can be useful when older log entries have been deleted from the log. After selecting menu item `Log - Import log' a window is opened that allows importing records for the `_Log' table. See Importing records, for a description on all import options.
8.5 Export Log
When the `_Log' table becomes large, it can be useful to export older log entries to an external file. To do this, choose menu item `Log - Export log'. This opens a window for exporting the records of the `_Log' table to a file. See Exporting records, for a description on all export options.
8.6 Clear Log
For clearing all entries of the log, choose menu item `Log - Clear log'. A typical case for clearing all log entries is when the `_Log' table becomes large. Make sure to export all entries to an external file prior to clearing the log.
8.7 View Log
By choosing menu item `Log - View log' the query editor is opened with a pre-defined query that lists all log entries. You can modify the query and its title, and MUIbase will remember the query. For more information, see Query editor.
This document was generated on September, 11 2016 using texi2html