[ic] Adding records to Oracle table with non-unique index?

Dan Browning interchange-users@icdevgroup.org
Fri Oct 11 18:18:15 2002


At 02:43 PM 10/11/2002 -0700, you wrote:
>Have a client who wants me to insert a record into an oracle table which 
>has a non-unique index (key) column, purposely to allow multiple entries 
>with the same index value. It seems that every data table writing method 
>in Interchange is designed to prevent this, updating the first matching 
>record found instead of writing a new one. Anybody have any ideas on how I 
>can force IC to blindly insert the new record into the table?

I've been bitten by this one as well -- there are a lot of places where the 
UI isn't well-suited for tables without a unique key.  For me, it was 
easier to add an additional key that was unique than it was to modify the 
UI to do what I wanted.

--
/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
Oh, I don't blame Congress.  If I had $600 billion at my disposal, I'd
be irresponsible, too.
                 -- Lichty & Wagner