Unable to Insert - Please help me!!

[Guest_imported]

I have just created a form that has both database items as well as non-database items.
The properties of the non-database items have been changed.
example, query allowed = no
insert allowed = no
update allowed = no
database item = no.
What I am having problem with right now is trying to insert records into the database items.
I have been receiving error: FRM-40508:Oracle error: Unable to insert record.
The form needs to have the ability to insert records into the items that are database fields and save them into the table. It is not working here.
Can anyone please help me!!!

 

[lewisp]

Make sure you have set the 'Database Item' property to 'No' fo all non-database items. Also check the Column Name property for every database item.

If you still have trouble, create an ON-ERROR trigger and call the DISPLAY_ERROR built-in from there to display the insert statement the form is trying to run.