Home » Developer & Programmer » Forms » do you want to save message (oracle forms 6i)
do you want to save message [message #355513] Fri, 24 October 2008 10:41 Go to next message
Messages: 2
Registered: October 2008
Junior Member
Hi every one,

I am developing a form which has one data block. Three fields are used for search. When I enter values in to these fieds and click search, I am getting 'Do you want to save' message. After this message the search is executed.

This message is showed because the search fields is considered to be modified. Can anyone tell me how to avoid this message. CAn any one please help me.

Re: do you want to save message [message #355593 is a reply to message #355513] Sat, 25 October 2008 23:54 Go to previous messageGo to next message
Messages: 44
Registered: August 2008
Location: Coimbatore
you can supress this message. Try to give like this


this will supress all the messages which is having level <= 20.
Re: do you want to save message [message #355806 is a reply to message #355513] Mon, 27 October 2008 12:15 Go to previous messageGo to next message
Messages: 12820
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is there any reason why you aren't using the standard enter-query/execute-query functionality?
Because if you assign values to those fields in enter-query mode you won't get that message.
Re: do you want to save message [message #355858 is a reply to message #355513] Tue, 28 October 2008 02:26 Go to previous message
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
You are entering values in the fields without being in ENTER-QUERY mode. So when you click your search button, normally you are executing query, and it's normal to have this message.
You have two solutions:

  1. Use the normal ENTER-QUERY/EXECUTE-QUERY functionality as proposed before.
  2. Create another non-database datablock where you put your search fields with the search button, and fetch (execute-query) your result in the based block.

Previous Topic: How to restrict input data
Next Topic: how to check the input value : number or string?
Goto Forum:

Current Time: Sat Aug 19 08:16:49 CDT 2017

Total time taken to generate the page: 0.11061 seconds