Home » Developer & Programmer » Forms » after execute_query , always ask to save the changes (10g)
after execute_query , always ask to save the changes [message #338968] Wed, 06 August 2008 06:17 Go to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi;
In master detailed form , I use the following code at the master block to invoke LOV and to get related detailed data
declare
	v_lov boolean;
begin
	v_lov :=show_lov('lov_user');
	--
	if v_lov =yes then
	    go_block('form_prv');
            execute_query;
	else
		null;
		end if;
        --  				
end;

my problem is however the data is updated or not, when exit the form it always ask to save the changes.
thanks
Re: after execute_query , always ask to save the changes [message #338970 is a reply to message #338968] Wed, 06 August 2008 06:20 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Hi dear,

Please check whether there is any code in your POST-QUERY trigger , that updated any database field.

Regards
Sasi...
Re: after execute_query , always ask to save the changes [message #338987 is a reply to message #338970] Wed, 06 August 2008 06:58 Go to previous messageGo to next message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
sasipalarivattom wrote on Wed, 06 August 2008 06:20
Hi
Please check whether there is any code in your POST-QUERY trigger , that updated any database field.


hi, dear

nothing there

thanks for your concern
Re: after execute_query , always ask to save the changes [message #340101 is a reply to message #338987] Mon, 11 August 2008 08:13 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Hi Dear,

However, use this code at the end of Post-Query trigger and try.

  set_record_property(:system.trigger_record,:system.trigger_block,status,query_status);


Good Luck...
Re: after execute_query , always ask to save the changes [message #340193 is a reply to message #340101] Mon, 11 August 2008 19:51 Go to previous message
amdabd
Messages: 91
Registered: November 2007
Location: My Computer
Member
hi, dear sasipalarivattom
sasipalarivattom wrote on Mon, 11 August 2008 08:13
set_record_property(:system.trigger_record,:system.trigger_block,status,query_status);



thanks v. much , now it works as I wish
Previous Topic: CHANGE MDI BACKGROUND COLOR
Next Topic: Replace system message with customized one
Goto Forum:
  


Current Time: Mon Dec 05 05:09:38 CST 2016

Total time taken to generate the page: 0.10212 seconds