OraFAQ Forum: Forms » see my error frm-40401 : no change to

Home » Developer & Programmer » Forms » see my error frm-40401 : no change to

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

see my error frm-40401 : no change to [message #173199]

Sat, 20 May 2006 03:05

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

Report message to a moderator

Re: see my error frm-40401 : no change to [message #173334 is a reply to message #173199]

Sun, 21 May 2006 23:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In a Form 'commit'='commit_form', what you need to use is 'standard.commit.

David

Report message to a moderator

Re: see my error frm-40401 : no change to [message #173419 is a reply to message #173199]

Mon, 22 May 2006 07:22

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

Report message to a moderator

Re: see my error frm-40401 : no change to [message #173434 is a reply to message #173419]

Mon, 22 May 2006 07:57

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: see my error frm-40401 : no changes to Save [message #184267 is a reply to message #173334]

Tue, 25 July 2006 23:14

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 1910 times)

Report message to a moderator

Re: see my error frm-40401 : no change to [message #184481 is a reply to message #173199]

Wed, 26 July 2006 14:03

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

Report message to a moderator

Re: see my error frm-40401 : no change to [message #512131 is a reply to message #184481]

Fri, 17 June 2011 02:24

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 1167 times)

Report message to a moderator

Re: see my error frm-40401 : no change to [message #512290 is a reply to message #512131]

Fri, 17 June 2011 23:55

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.

Report message to a moderator

Previous Topic:	Log in Form in forms 10g
Next Topic:	placing the cursor in the textfield

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 16:09:58 CDT 2024