Unique Override Registry entry

Specify that a user / group can save a record even if a Unique Registry entry specifies that a column or a combination of columns must be unique in order to save a record and that column or combination of columns is not unique.

The Unique Registry entry specifies that a column or a combination of columns must be unique in order to save a record. If the column or combination of columns is not unique (or empty), the record cannot be saved and a message displays warning the user to make the column or combination of columns unique.

With the Unique Override Registry entry it is possible to specify that users / groups are able to save a record that violates uniqueness.

Usage

This Registry entry can be assigned to users and groups:

Key User User Group Group Group Group
Key 1 User User Group Group Group Group
Key 2 user user group group Default Default
Key 3 Table Table Table Table Table Table
Key 4 table Default table Default table Default
Key 5 Unique Override
Key 6 column;column;...
Value boolean
User user Table table Unique Override column;column;... boolean
User user Table Default Unique Override column;column;... boolean
Group group Table table Unique Override column;column;... boolean
Group group Table Default Unique Override column;column;... boolean
Group Default Table table Unique Override column;column;... boolean
Group Default Table Default Unique Override column;column;... boolean

where:

column;column;...

must match the column list specified in the Unique Registry entry to be overridden.

boolean

is true or false.

If true, the user / group will be informed that the column or combination of columns is not unique, but will be asked if they want to continue with saving the record. An affirmative response will continue with saving the record. A negative response will abort the save and move the cursor to the control associated with the first column listed in the Unique Registry entry.

If false, the record will not be saved and the warning message specified in the Unique Registry entry will display; the cursor will move to the control associated with the first column listed in the Unique Registry entry.

Note: If this entry is not present, a setting of false is assumed.

Example

This entry allows users in the Admin group to override the uniqueness constraint specified in the previous Unique Registry entry:

Key Setting
Key 1 Group
Key 2 Admin
Key 3 Table
Key 4 eparties
Key 5 Unique Override
Key 6 BioBirthDate;NamFirst;NamLast
Value true