Unique key

With the unique key option you can inform which fields’ data should not have repetitions within the database.

Unique key configuration Interface. Unique key configuration Interface

If you want to combine two or more fields as unique, select the fields by holding the CTRL key of your keyboard and then click on the “Add” button.

The user will receive message if tries to insert a repeated value into the application. The validation and message are created automatically by Scriptcase, you are able to customize it by accessing the application language option and searching for the lang variable: {lang_errm_inst_uniq}. This lang variable contains a pre-set error message content.

Unique key message example. Unique key message example