How To make a Table column Unique.

(6 votes, average: 3.33 out of 5)

 Loading ...

This is quite rare requirement as you don’t create custom tables often in Siebel. But if you happen to do that then most probably you will want to make the some of the columns unique which will identify the record as unique.

Requirement:

Make two columns of a table unique . For example I created a table called CX_ERR_MSG and I would like the field ERR_CODE and ERR_LANG to be Unique so that no duplicate records can be created.

Solution:

The most obvious and least recommended solution of course is scripting. On Buscomp PreWrite event you check weather the values entered in the record are already existing or not.

Recommended Solution:

A better and recommended solution for this is to make the fields unique at database level. Here is Step by Step guide on making a coloumn unique at table level.

Download Guide

Let me know your views about the guide. It will help me to decide about my future posts.