Re: Unable to insert record in oracle form

Phoebe,

   Based on your statements that when you remove the PK constraint, two records are inserted, and that with the PK constraint in place you get a 'duplicate record' error message; it seems certain that Forms is attempting to insert the same record twice. Do you have a trigger on the Form that duplicates the actions of the SAVE button and that could be firing when you save the record with the SAVE button? Regards,
Paul

In article <87g88s$jnm$1_at_news.ctinets.com>,   "Phoebe Ho" <phoebe_at_hkem.com> wrote:
> I tried to truncate the table before insertion. But it fail again.
>
> Phoebe
>
> SKurosky <skurosky_at_aol.com> wrote in message
> news:20000204111230.24821.00001218_at_ng-ce1.aol.com...
> > >Phoebe Wrote:
> >
> > > I am writing a program to insert record in form builder.
> > > When i press "save" button and an error is raised.
> > >
> > > FRM-40508: oracle error : unable to insert record.
> > > table : cus_id varchar2(10) primary key,
> >
> > Are you trying to insert a record with duplicate cust_id? That is
what the
> > "Primary Key" constraint is there to guard against. You should not
have
> > duplicate cust_id.
> > Sandy
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Feb 05 2000 - 05:21:16 CST