Re: Checking if combination is unique
The simplest way is to create the table with ...
PRIMARY KEY( personalid,groupid ), and have app check for INSERT failures.
And/or have your form check for existence of a row with a given ( personalid, groupid ) value pair to ensure that such a pair does not exist, before an INSERT is attempted from a form.
PB
Subject
Written By
Posted
Re: Checking if combination is unique
July 07, 2007 01:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.