Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Forms and Tables with a Multiple-field Primary Key... help!!!
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
![]() |
![]() |