Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Forms and Tables with a Multiple-field Primary Key... help!!!

Re: Oracle Forms and Tables with a Multiple-field Primary Key... help!!!

From: Hakan Eren <heren_at_erpdbo.com>
Date: 1998/03/24
Message-ID: <3517B7B6.20A01DEE@erpdbo.com>#1/1

Hi Dennis,

Two reasons for this error:
1) The row duplicates an existing value in the primary key. 2) It may contain a null value (or one of them) for the primary key.

You may use Help/Display Error from the menu to see the more detailed error.

Good Luck

Hakan Eren

Dennis Spathis wrote:

> I have a table ITEMPRICE containing the fields ITEMID, DATE, PRICE and
> DISCOUNT. The primary key is a multiple-field primary key consisting of the
> first two fields.
>
> Here is my problem: the form I created for the purpose of data entry into
> this table will not permit insertion of a record (all attempts result in the
> generic "ORACLE ERROR: Cannot insert the record" message).
>
> I know my table is fine--I can insert data via the Oracle browser. I am
> also quite confident that my form is fine (it is simple enough, and anyway,
> I created it in the same way I created my other forms--which work
> perfectly).
>
> I suspect the problem has to do with the multiple-field primary key.
>
> Any clue what's going on? What should I do?
>
> Thanks.
Received on Tue Mar 24 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US