Re: Can't update record - dup_val_on_index

This is not happening.
Update commands do not insert new records. There is something else in your code that is doing the inserts.

--
Paul Dorsey
Dulcian, Inc.
(212) 595-7223
web address: http://www.dulcian.com
email: pdorsey_at_dulcian.com

Phoebe <phoebe_at_hkem.com> wrote in message news:88or27$rcs$1_at_news.ctinets.com...
> The customer table only have a primary key on ID.
> But when i drop the primary key, I can update the record successfully.
> However it will also insert one more same record into the table.
> Can anyone tell me how can i update the record without insert one more
same
> record??
> Thanks in advance.
>
> Phoebe
>
> Paul Dorsey <pdorsey_at_dulcian.com> wrote in message
> news:LiRr4.15115$pN1.219098_at_news1.rdc1.nj.home.com...
> > Look at what indexes are on the table.
> > You probably have a unique index on name.
> >
> > --
> > Paul Dorsey
> > Dulcian, Inc.
> > (212) 595-7223
> > web address: http://www.dulcian.com
> > email: pdorsey_at_dulcian.com
> >
> >
> > Phoebe <phoebe_at_hkem.com> wrote in message
> > news:88oec7$nm8$1_at_news.ctinets.com...
> > > Dear all,
> > >
> > > I am writing application to update the record. I try to update the
> > > record when the "save" button pressed. But it throws an exception :
> > > dup_val_on_index
> > >
> > > cursor cur_cus is select * from customer
> > > where :id = id
> > > for update nowait;
> > > val_cus cur_cus%rowtype;
> > >
> > > if cur_cus%found then
> > > update customer set name = :name,
> > > address = :address
> > > where id = :id;
> > > commit;
> > >
> > > Can anyone tell me why dup_val_on_index raised when i update the
record
> ??
> > > Thanks in advance.
> > >
> > > Phoebe
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Feb 21 2000 - 06:23:15 CST