OraFAQ Forum: Forms » after execute_query , always ask to save the changes

Home » Developer & Programmer » Forms » after execute_query , always ask to save the changes (10g)

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

after execute_query , always ask to save the changes [message #338968]

Wed, 06 August 2008 06:17

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

Report message to a moderator

Re: after execute_query , always ask to save the changes [message #338970 is a reply to message #338968]

Wed, 06 August 2008 06:20

sasipalarivattom
Messages: 121
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...

Report message to a moderator

Re: after execute_query , always ask to save the changes [message #338987 is a reply to message #338970]

Wed, 06 August 2008 06:58

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

Report message to a moderator

Re: after execute_query , always ask to save the changes [message #340101 is a reply to message #338987]

Mon, 11 August 2008 08:13

sasipalarivattom
Messages: 121
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...

Report message to a moderator

Re: after execute_query , always ask to save the changes [message #340193 is a reply to message #340101]

Mon, 11 August 2008 19:51

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

Report message to a moderator

Previous Topic:	CHANGE MDI BACKGROUND COLOR
Next Topic:	Replace system message with customized one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 09:30:28 CST 2025