Home » Developer & Programmer » Forms » Default_where
Default_where [message #677989] Tue, 29 October 2019 04:13 Go to next message
Amir_7912
Messages: 2
Registered: July 2018
Junior Member
Dear All,
In form i create list Administration when i select CAD Finalization when query not execute in block please Help me

	DECLARE
		V_WHERE	 VARCHAR2(2000);
	BEGIN
		V_WHERE:=NULL;
	 	GO_BLOCK('SRL_DESIGN_PLAN_HDR');
		IF :ADMINISTRATION='CAD Finalization' THEN
			SET_BLOCK_PROPERTY('SRL_DESIGN_PLAN_HDR',DEFAULT_WHERE,'CAD_AKNLG=''YES''');	
			EXECUTE_QUERY;
		END IF;	
        END;


[EDITED by LF: applied [code] tags]

[Updated on: Fri, 08 November 2019 16:21] by Moderator

Report message to a moderator

Re: Default_where [message #677991 is a reply to message #677989] Tue, 29 October 2019 05:33 Go to previous message
cookiemonster
Messages: 13759
Registered: September 2008
Location: Rainy Manchester
Senior Member
What trigger is that code in?
Have you debugged it (put messages in) to check that :administration is set to the value you think it is and that the code in the IF is getting executed?
Are you getting an error? If so what?
Previous Topic: Form 10g Run using local host
Next Topic: Menu not mapping in Oracle form 12c
Goto Forum:
  


Current Time: Sat Dec 14 18:03:24 CST 2019