Home » Developer & Programmer » Forms » How to get rid of FRM-41051 error?
How to get rid of FRM-41051 error? [message #82693] Mon, 23 June 2003 13:08 Go to next message
Messages: 78
Registered: June 2002
I have a form with master detail blocks and the block properties are set to no inserts, no updates, and no deletes. When I am at the last record and whenever I navigates to the next record, the system gives a message “FRM-41051: You cannot create records here”. Then the system is not allowing me to go back to anywhere and it insists me with a message “FRM-40202: Field must be entered”. The if I try to exit the form it says “Do you want to call the new form?” How to get rid of this? I am unable to figure out and appreciate in advance for any valuable help.
Re: How to get rid of FRM-41051 error? [message #82695 is a reply to message #82693] Mon, 23 June 2003 16:59 Go to previous messageGo to next message
Messages: 98
Registered: February 2002
In tabbing beyond the last record, you are telling the form that you want to add a record, hence the message. To get rid of it, I suggest you create an on-error trigger, check for this error number and suppress the message.

lv_errcod NUMBER := ERROR_CODE;
lv_errtyp VARCHAR2(3) := ERROR_TYPE;
lv_errtxt VARCHAR2(80) := ERROR_TEXT;
IF (lv_errcod = 41051) THEN
Message(lv_errtyp||'-'||to_char(lv_errcod)||': '||lv_errtxt);
RAISE Form_Trigger_Failure;

To get rid of the "Field must be entered" change the property of that column to be not required. Since you are not changing or creating data here, it doesn't matter.
Re: How to get rid of FRM-41051 error? [message #597282 is a reply to message #82695] Wed, 02 October 2013 12:54 Go to previous message
Messages: 3
Registered: May 2011
Junior Member
Above the explanation.

If the record is in looping, just put the following command, BEFORE command NEXT_RECORD:


Previous Topic: Problem with the Web.Show_document method
Next Topic: master/detail forms
Goto Forum:

Current Time: Tue Aug 22 15:49:55 CDT 2017

Total time taken to generate the page: 0.12807 seconds