OraFAQ Forum: Forms » FRM-40401 No Save to Change

Home » Developer & Programmer » Forms » FRM-40401 No Save to Change (ORACLE 10g)

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

FRM-40401 No Save to Change [message #512113]

Fri, 17 June 2011 01:23

ADEEL AHMED
Messages: 4
Registered: June 2011
Location: Karachi,Pakistan

Junior Member

Hi every One...
I have updated a table from the form and written a update statement ON block level trigger ON-UPDATE

"UPDATE_RECORD;
update employees set hiredate=to_date(:EMP.TXT_DATE,'dd-MON-yyyy')
where employees.empno=:emp.empno;
COMMIT_FORM;"

Here employees is my table and emp is my block
I am a new user of Oracle 10g.
Can any one help me.......

Report message to a moderator

Re: FRM-40401 No Save to Change [message #512116 is a reply to message #512113]

Fri, 17 June 2011 01:30

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why are you updating it that way? It seems that all information you need is in a form (i.e. :EMP.TXT_DATE => EMPLOYEES.HIREDATE for EMPLOYEES.EMPNO = :EMP.EMPNO). I guess that default Forms processing is capable to update that value, if items belong to a database block.

Forms says that there are no changes to be saved (as nothing has changed in a block). You might try to use STANDARD.COMMIT (instead of COMMIT_FORM). Also, search the board, as such a question has already been discussed many times.

Report message to a moderator

Re: FRM-40401 No Save to Change [message #512122 is a reply to message #512116]

Fri, 17 June 2011 01:48

ADEEL AHMED
Messages: 4
Registered: June 2011
Location: Karachi,Pakistan

Junior Member

Actually I have 7 Different Items.

2 are text item for day
1 is list item which for Month
and other 4 are text Item for Year
that's why i need to updating it in that way. Hope you understand...

when i try to use STANDARD.COMMIT this is also show same error..

Report message to a moderator

Re: FRM-40401 No Save to Change [message #512147 is a reply to message #512122]

Fri, 17 June 2011 03:37

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

No you don't need to update it that way.
Get rid of the on-update trigger.
Put a hiredate item in your block if there isn't one already (it doesn't have to be on the canvas).
Modify it from the when-validate-item triggers on the 7 items.

Better yet, just get rid of the 7 items and have users alter hire_date directly.
Why 7 items for 1 date?

Report message to a moderator

Re: FRM-40401 No Save to Change [message #512155 is a reply to message #512147]

Fri, 17 June 2011 04:32

ADEEL AHMED
Messages: 4
Registered: June 2011
Location: Karachi,Pakistan

Junior Member

when-validate-item triggers
also not working.

and Why 7 items for 1 date?
Because I need HIRE DATE like shown in Screen shoot.

Attachment: SCOTT_FORM.JPG
(Size: 33.77KB, Downloaded 797 times)

Report message to a moderator

Re: FRM-40401 No Save to Change [message #512156 is a reply to message #512155]

Fri, 17 June 2011 04:40

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

What did you put in the when-validate-item triggers?
And you might want to consider using a calender LOV (search this forum) rather than doing what you are doing.

Report message to a moderator

Re: FRM-40401 No Save to Change [message #512166 is a reply to message #512156]

Fri, 17 June 2011 05:12

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SCOTT_FORM.JPG is really a unique example of how to enter date values. What an idea!

Report message to a moderator

Previous Topic:	save button(updation)
Next Topic:	Log in Form in forms 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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