Database history

The Database history facility provides a way for uses to view changes that have occurred to a database and to add their own records detailing any changes, problems or other issues relating to the database as a whole.

Whenever a database changes, be it the structure or use, a database history record should be added. This will then allow a user a see what changes have occurred and when.

When the use of the Database Upgrade facility causes changes to the structure of a database, a database history record will automatically be added to the database.

  • No practical limit to the number of database history entries that can be added
  • Each database history entry date and time stamped
  • Upgrade tool automatically adds database history entries

Module: System

Category: Database history

Activation: Main > System > Database administration > Database history

Form style: Multiple instance, SODA

Special actions available for users with Administrator permissions:

  • None

Database rules:

  • Internal entries (added by Database Upgrade facility) cannot be edited or deleted

Reference: list, read-only

This is a list of all changes that have been made to the current database. The list consists of three columns as follows:

  • ID: Unique server-assigned ID by which database history records are identified
  • Date: The date the database history record was added
  • Summary: The brief summary entered for the database history record

The list may also contain a number of records with a icon on the left: this indicates that this item has been added by the Database Upgrade facility and as such cannot be edited or deleted.

When you are ready to modify or delete a non-internal record, ensure that you have selected it in the list before clicking on the Edit or Delete button.

Reference: text, read-only

These are the details that have been entered for the database history item.

Double clicking this field will cause the field to be expanded the same as pressing the Quicklist key

Reference: button

Clicking the new or edit buttons will open the Database history item entry form, allowing you to create or modify a database history record.

Reference: date, mandatory, QuickList

This is the date on which the Database change was made.

Reference: text(50)

This is a brief summary explaining the change that was made. This is the summary that appears in the list of database history activities.

Reference: memo, expandable

This is the expanded information about the database change and should include the details of the change as well as the reasons for making the change.