SQL Database Definition actions

Create New SQL Database Definition

This action is carried out using the Create new SQL Database Definition toolbar button. The new definition’s name is ‘New SQL Database Definition’ (an incrementable integer can be appended to ensure uniqueness). Contact rules are enabled automatically at a new SQL database definition.

Configure Existing SQL Database Definition

This is carried out in the Selected SQL Database Definition Details section. If you configure a definition that has been saved previously, its State is set to Edited.

Delete Selected SQL Database Definitions

This is carried out in the toolbar.  A deleted definition's State is set to Deleted.  Its row text color is set to red. You may no longer select a deleted row. If required, you can delete multiple definitions at the same time.

Save Changes to SQL Database Definitions

Save is carried out using the Save changes to SQL Database Definitions toolbar button.  Any changes you have made are validated, and any validation errors are advised in a dialog. You may not proceed with the Save until you have resolved them.

Following a successful save, definitions are displayed in alphabetical order. All states are updated to Unchanged. Any deleted definitions are removed from display.

Refresh

This option reloads the contents of the interface from the operational database. If changes have been made, a ‘Save Changes?’ dialog is shown.