Miscellaneous Configuration Options

This tab page groups the miscellaneous configuration options.

Startup Sound

You can select a sound that needs to be played when Database Explorer starts. Only “wave” (.WAV) files can be selected and played. The default is no sound.

Name Display (in list of tables)

The list of tables can only show one of the three available names out of the filelist. By default, the user display name (DF_FILE_DISPLAY_NAME) attribute value will be used. If you are better served with the root (DF_FILE_ROOT_NAME) or the logical (DF_FILE_LOGICAL_NAME) name, you can change the choice here.

Performance Setting

This is a performance setting. The most significant columns of a table are usually in the range of 1-20. This configuration option, with a default of 20, will be used when you open a table in grid mode and no stored previous settings can be found. The data grid operates slower when the number of columns is increased. The real maximum number of columns in a grid is 255.

Error Log

All errors that occur during operation can be logged in a text file. If you enter a folder and filename here, that file will be used to log the errors. The default is none.

Write Data Changes to Logfile

This option, when turned on, writes changes to the data into a logfile. When turned on, a file named "Database Explorer Data Changes.log" gets created in the first existing folder of the workspace's idesrcpath.

Example Logfile Entries

25,"Customer","01000000","31-8-2021 13:32:03,395","DAW","Edit",4
25,"Customer","01000000","31-8-2021 13:32:48,874","DAW","Edit",4
25,"Customer","","31-8-2021 13:35:06,441","DAW","Create",1,2
25,"Customer","65000000","31-8-2021 13:35:13,544","DAW","Delete"

In the case of a create, the 3rd value (rowId) is blank. In the case of edit and create, the column numbers with a change are listed, separated by a comma, at the end of the line. The first column is the table number, the second is the name of the table, the fourth is the date and time of the change, the fifth is the current user name, and the sixth is the operation (edit, create, delete).