Home » Developer & Programmer » Forms » How to supress "Do you want to save the changes you have made"
How to supress "Do you want to save the changes you have made" [message #390070] Wed, 04 March 2009 17:42 Go to next message
rosetulip
Messages: 6
Registered: January 2009
Junior Member
I use the following line

BEGIN
EXIT_FORM(NO_VALIDATE, NO_COMMIT);
END

in key-exit trigger in the form level. when I re-guery the form, this message comes up even I don't make any changes

For example,

I open the form-->from the menu-->>Query->Enter an ID--->Run, then I empty the ID field by backspace/delete, and do "Query->Enter again, the ask if save message popped up.

So, how to fix this?
Re: How to supress "Do you want to save the changes you have made" [message #390076 is a reply to message #390070] Wed, 04 March 2009 18:41 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
You might believe you haven't made changes but you have.

There is some code somewhere in your form that is changing a database item.

Fix that code.
Re: How to suppress "Do you want to save the changes you have made" [message #390077 is a reply to message #390076] Wed, 04 March 2009 18:57 Go to previous messageGo to next message
rosetulip
Messages: 6
Registered: January 2009
Junior Member
I have a post_query trigger that may do something to the field. But I don't want to change the code in post_query trigger, instead, I want to ignore the change until I hit save to commit. I can close the form without a problem, but , just requery another item, this message popped up.
Re: How to supress "Do you want to save the changes you have made" [message #390105 is a reply to message #390070] Wed, 04 March 2009 23:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Your form is updating an item based on a database field.

You will need to check your form and make sure that no item has been inadvertently made database 'true' or that you have code which is populating an item when it should not be populated.

Verify that all triggers that have 'Fire in Enter Query Mode' set to 'True' are ones that your really DO want to fire in 'enter query' mode.

David
This answer was to the duplicate of your post which I have merged and deleted.

[Updated on: Wed, 04 March 2009 23:49]

Report message to a moderator

Re: How to suppress "Do you want to save the changes you have made" [message #390153 is a reply to message #390077] Thu, 05 March 2009 04:10 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
rosetulip wrote on Thu, 05 March 2009 00:57
I can close the form without a problem, but , just requery another item, this message popped up.


That's how it's designed to work

rosetulip wrote on Thu, 05 March 2009 00:57
But I don't want to change the code in post_query trigger, instead, I want to ignore the change until I hit save to commit.


You're out of luck. If your post-query trigger is changing the record status - fix it.
Re: How to suppress "Do you want to save the changes you have made" [message #390246 is a reply to message #390153] Thu, 05 March 2009 11:00 Go to previous messageGo to next message
rosetulip
Messages: 6
Registered: January 2009
Junior Member
I fix the post_query trigger to changing the item as non-database item. This message is gone. However, it comes up another problem. for example, I have 2 records whose status are "good" and "fair"

When I open the form, one record shown its status, another one I have to click on the second one then show the record. I don't know why?
Re: How to supress "Do you want to save the changes you have made" [message #390247 is a reply to message #390070] Thu, 05 March 2009 11:02 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
What trigger is being to used to determine the status?
Re: How to supress "Do you want to save the changes you have made" [message #390248 is a reply to message #390247] Thu, 05 March 2009 11:04 Go to previous messageGo to next message
rosetulip
Messages: 6
Registered: January 2009
Junior Member
post_query trigger
Re: How to supress "Do you want to save the changes you have made" [message #390250 is a reply to message #390070] Thu, 05 March 2009 11:07 Go to previous message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
You need to explain in more detail what the issue is.
Previous Topic: onetime_where property of oracle form
Next Topic: APP-FND-01206
Goto Forum:
  


Current Time: Sun Dec 04 00:13:56 CST 2016

Total time taken to generate the page: 0.06708 seconds