| proplem in displaying user id and date in the form [message #282512] |
Thu, 22 November 2007 03:55  |
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 #282810 is a reply to message #282512] |
Fri, 23 November 2007 12:21  |
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;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
