Home » Developer & Programmer » Forms » FRM-40702 Cannot call form with changes to save (Oracle Forms 10G)
FRM-40702 Cannot call form with changes to save [message #356198] Wed, 29 October 2008 23:09 Go to next message
rodneyf
Messages: 4
Registered: October 2008
Junior Member
I have encountered an odd problem. When any database item is changed, calling function call_form will raise error FRM-40702 Cannot call form with changes to save. But if I haven't done any change to the database item, the call_form can be called normally.

What should I do if I want the call_form goes normally even if there is change in database item?

Any ideas?
Re: FRM-40702 Cannot call form with changes to save [message #356258 is a reply to message #356198] Thu, 30 October 2008 01:46 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Save them.

David
Re: FRM-40702 Cannot call form with changes to save [message #356270 is a reply to message #356258] Thu, 30 October 2008 02:15 Go to previous messageGo to next message
rodneyf
Messages: 4
Registered: October 2008
Junior Member
Thanks for your reply.

But I think raising this error is abnormal as I can perform call_form even without commit in the past.

Also, you can try to perform call_form after modifying the database item to see if Error FRM-40702 ocurrs.
Re: FRM-40702 Cannot call form with changes to save [message #356299 is a reply to message #356270] Thu, 30 October 2008 04:26 Go to previous message
rodneyf
Messages: 4
Registered: October 2008
Junior Member
Problem solved.

Set the savepoint mode to TRUE programmatically by SET_FORM_PROPERTY

However, according to the Help, the default value for savepoint mode should be "Yes" already and I have NOT modified that property by myself before.

Previous Topic: ms agent to oracle form 6i
Next Topic: LOGON Block in FOrm
Goto Forum:
  


Current Time: Sat Dec 03 12:26:18 CST 2016

Total time taken to generate the page: 0.08576 seconds