Home » Developer & Programmer » Forms » proplem in displaying user id and date in the form (developer 10G)
proplem in displaying user id and date in the form [message #282512] Thu, 22 November 2007 03:55 Go to next message
LAZYGIRL
Messages: 34
Registered: May 2006
Member
I have form with parameter named user_id

and i put display item called user_id to display it

i put the code in when_new_form_instance

:request_master.user_id := :parameter.user_id;
		
		
	
		GO_BLOCK ('request_master');
		
		IF FORM_SUCCESS THEN
		
			 :system.message_level:=5;
 			 EXECUTE_QUERY;        
 			 :system.message_level:=0;  
		ELSE
			
			alert_id := msgbox('common_alert','Cannot Navigate to Request Master');
		
		END IF ;
		
			 



put there is proplem to navigate to the block

plze help

Re: proplem in displaying user id and date in the form [message #282516 is a reply to message #282512] Thu, 22 November 2007 04:18 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
what error is it shown.
do you have a navigable item in the block and on canvas as well.
Re: proplem in displaying user id and date in the form [message #282528 is a reply to message #282512] Thu, 22 November 2007 04:39 Go to previous messageGo to next message
LAZYGIRL
Messages: 34
Registered: May 2006
Member
it give me this message


'Cannot Navigate to Request Master' which is my msg


if i remove the

:request_master.user_id := :parameter.user_id;


it wont give the msg

i donr know why

Re: proplem in displaying user id and date in the form [message #282532 is a reply to message #282528] Thu, 22 November 2007 04:46 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
ok just reomove the "if form_success" condition and check it now
Re: proplem in displaying user id and date in the form [message #282810 is a reply to message #282512] Fri, 23 November 2007 12:21 Go to previous messageGo to next message
LAZYGIRL
Messages: 34
Registered: May 2006
Member
i remove this code


IF FORM_SUCCESS THEN
		
			 :system.message_level:=5;
 			 EXECUTE_QUERY;        
 			 :system.message_level:=0;  
		ELSE
			
			alert_id := msgbox('common_alert','Cannot Navigate to Request Master');
		
		END IF ;


but it give me field must be entred as soon as i open the form

this is the the code after i change it

		Set_Window_Property(FORMS_MDI_WINDOW, WINDOW_STATE, MINIMIZE);
		SET_WINDOW_PROPERTY('Request_win', WINDOW_STATE , MAXIMIZE); 
	:REQUEST_MASTER.SYSTEMDATE:=SYSDATE;
	:REQUEST_MASTER.USERID:=:PARAMETER.USER_ID;
			
		
		GO_block ('request_master');
execute_query;




Re: proplem in displaying user id and date in the form [message #282885 is a reply to message #282512] Sat, 24 November 2007 12:01 Go to previous message
LAZYGIRL
Messages: 34
Registered: May 2006
Member
i solve the proplem i put the code in post query
and it work

Previous Topic: I CANNOT RUN REPORTS FROM PROGRAM
Next Topic: DATE issues in Forms
Goto Forum:
  


Current Time: Tue Dec 06 12:27:16 CST 2016

Total time taken to generate the page: 0.09657 seconds