Home » Developer & Programmer » Forms » see my error frm-40401 : no change to
see my error frm-40401 : no change to [message #173199] Sat, 20 May 2006 03:05 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member

hi master
sir i put this code in when_button_press event

nsert into opbaltable (chofacc)
(select chofacc from chart_of_account where acc_date='01-JUL-05');
commit;
commit_form;

but system give me this error

frm-40401 : no change to save


please give me idea how in insert data from other table

thank

Re: see my error frm-40401 : no change to [message #173334 is a reply to message #173199] Sun, 21 May 2006 23:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In a Form 'commit'='commit_form', what you need to use is 'standard.commit.

David
Re: see my error frm-40401 : no change to [message #173419 is a reply to message #173199] Mon, 22 May 2006 07:22 Go to previous messageGo to next message
gacki
Messages: 33
Registered: May 2006
Location: Dueren, NRW, Germany
Member
The first commit writes the data to the database and synchronizes form and db. So the second commit_form; has nothing to do, and that's what it says: no changes to save.

Gerald
Re: see my error frm-40401 : no change to [message #173434 is a reply to message #173419] Mon, 22 May 2006 07:57 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The first commit only 'writes' the data if the form thinks that something has been changed IN THE FORM and it passes the commit on to the database. If the form does not think that anything has been changed IN THE FORM then it does NOT pass the commit to the database. Use the 'standard.commit'.

David
Re: see my error frm-40401 : no changes to Save [message #184267 is a reply to message #173334] Tue, 25 July 2006 23:14 Go to previous messageGo to next message
kukde123
Messages: 1
Registered: July 2006
Location: Chennai
Junior Member
Hello Sir,

I am getting same frm-40401 error.
I tried to use standard.commit in place of commit but it didnt work. I am new to forms. Please guide me.

i wrote a code on a button when-button-pressed.
In this i have assigned values to two global variables.
followed by insert statement;
commit;
then called 1 procedure which inserts data into many tables. This procedure contains commit after every insert statement;

Regards,
Samruddhi
  • Attachment: frm-40401.doc
    (Size: 142.50KB, Downloaded 869 times)
Re: see my error frm-40401 : no change to [message #184481 is a reply to message #173199] Wed, 26 July 2006 14:03 Go to previous messageGo to next message
rahshar
Messages: 26
Registered: July 2006
Location: Oman
Junior Member
Dear All,

The Error FRM-40401 is actually not an error it is a message produced by the forms engine after every commit;

This can be suppressed by adding a statement before any DML statement such as

:system.message_level := 5;

Thanks and regards
Re: see my error frm-40401 : no change to [message #512131 is a reply to message #184481] Fri, 17 June 2011 02:24 Go to previous messageGo to next message
ADEEL AHMED
Messages: 4
Registered: June 2011
Location: Karachi,Pakistan
Junior Member
Sir,

I am a new user of ORACLE 10g.

I have a same problem. ON-INSERT Trigger and POST-QUERY Trigger work Successfully but I updated a table from the form and written a update statement ON block level trigger PRE-UPDATE
trigger it show the message.
Here is a fmb file of my form.

Sir please help me how i remove this problem
  • Attachment: SCOTT.fmb
    (Size: 64.00KB, Downloaded 149 times)
Re: see my error frm-40401 : no change to [message #512290 is a reply to message #512131] Fri, 17 June 2011 23:55 Go to previous message
rahshar
Messages: 26
Registered: July 2006
Location: Oman
Junior Member
The Error FRM-40401 is actually not an error it is a message produced by the forms engine after every commit;

This can be suppressed by adding a statement before any DML statement such as

:system.message_level := 5;

But this statement just below the begin statement of your code.
Previous Topic: Log in Form in forms 10g
Next Topic: placing the cursor in the textfield
Goto Forum:
  


Current Time: Tue Dec 06 16:29:37 CST 2016

Total time taken to generate the page: 0.08922 seconds