Forms 6i

[icecream]

I had created s form with the master-detail relationship. It compliles fine. But when i try to insert a record, delete a record or to enter a query by using the default menu bar, it gives me a warning message "Please acknowledge message". The errors i get are :

i) FRM 42401: Performs program trigger ON-CLEAR-DETAILS on form,
ii) FRM 42402: Performming program trigger ON-POPULATE-DETAILS from block 'block_name'

Why do i keep on getting these messages???

When I try to insert a record, they give me an error
"FRM 40508:ORACLE error: Unable to INSERT a record"

Why do i get this error???

please help........

thanks in advance......

[stecal]

Check these possible problems:

FRM-40508 : ORACLE error: unable to INSERT record.
Cause: A fatal error occurred while Oracle Forms was trying to insert a record. The table associated with the current block of the form might not exist, your username might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.

[icecream]

my table do exist. and my username is the oracle default username which is "system". What else can be wrong??? I still can't find the solution for it.....

[skid]

Hi.

Check Database Error (>Help>Display Error), maybe it would give you more detail on why the SQL Insert statement failed. My guess would be an FK error.

Hth,
skid