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

1. Most people use comp.databases.oracle.tools for Forms questions.
2. There is something wrong with your form, and it's probably nothing to do with the keys.
3. When you try to insert and get the message, press Shift-F1 (or click help->display error. This will show you the sql statement and the server error returned. You probably are leaving one required field null, or have accidentally set the property on one of your items to Base Table Item = False

HTH,
Steve Cosner
http://members.aol.com/stevec5088

In article <6f4jmi$56h$1_at_newsflash.concordia.ca>, Dennis Spathis <d_spathi_at_alcor.concordia.ca> 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 Mon Mar 23 1998 - 00:00:00 CST