DbAuditing

Top  Previous  Next

The DbAuditing template is a global extension used to track updates to specific data tables. This extension is added to the global properties of an application.

The DbAuditing template provides the following prompts:

Log Files

This tab contains a list box that lets you define log files and options for the files used in an application. Add a new log file definition by pressing the Insert button. This displays a dialog where you name the log file and define its contents. Use the and to change the order of the log files.

File to Log

Choose a file from the drop list that consists of all files defined in the dictionary. Any updates to this data file are written to its associated log file.

LogFile Name

Specifies the name of the log file to update.

Username Logging

The username logging option is used to track which user is making the update to the specific data file. It does this by adding an extra column to the log file for the user's login name.

Username variable

Specifies the variable which contains the current user. The value of this variable gets written to the log file to indicate the user who made the change to the data file.

Username Header

Specifies the header to be used in the log file for the user column.

Username picture

Specifies the format to be used for the user column in the log file.

File Fields to Log

This option gives the ability to customize a log file for each data file. For example, you may wish to log changes to certain fields and allow changes to others without logging them. Press insert to select a field to write to the log file. Use the and to change the order that the fields are logged to the log file.

Field

Specifies the field name for the data that is writen to the log file.

Field Header

Specifies the header to be used in the log file for the data column.

Field Picture

Specifies the format to be used in the log file for the data column.

Miscellaneous Fields to Log

This option gives the ability to customize a log file for miscellaneous data. Press insert to add a field to the log file. Use the and to change the order that the miscellaneous fields are logged to the log file.

Field

Specifies the field name for the data that is writen to the log file.

Field Header

Specifies the header to be used in the log file for the data column.

Field Picture

Specifies the format to be used in the log file for the data column.