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.
Let me know your views about the guide. It will help me to decide about my future posts.
(5 votes, average: 3.4 out of 5)
Loading ...
3 Comments at "How To make a Table column Unique."
That is fantastic….as a learner it helps me alot. Keep posting some good stuff like this. Thanks!
Unable to download the file. The solution is to add an user key at the table and specify which columsn form a part of that key
unable to download guide.
Plz arrange alternate option for download
Comment Now!