Home » Developer & Programmer » Forms » call from through menu with parameter (forms 6i)
call from through menu with parameter [message #441858] Wed, 03 February 2010 07:57 Go to next message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

any body tell me that how can i call form through menu bar with parameter...

i made a log-in form in which i take user name and i send it to called form in and which forms is called there i create a parameter of that name which i called log-in form...

but when now i reached it on second form there is i use menu.. than how can i send this user name to other forms which i called through menu bar....

I Use this code for calling form through log-in form...

but what can i do for call form with parameter through menu..

DECLARE
  ALRT   NUMBER;
  T_REC  NUMBER;
  UNAME  VARCHAR2(50);
  UPWD   VARCHAR2(50);
  pl_id  PARAMLIST;
  PNAME  VARCHAR2(100);
	
BEGIN

  SELECT USER_NAME, USER_PASSWORD, PERSON_NAME 
  INTO   UNAME,     UPWD,          PNAME
  FROM ORGANIZATION.USER_ACCOUNT
  WHERE USER_NAME     = :LOGIN_BLOCK.USER_NAME 
  AND   USER_PASSWORD = :LOGIN_BLOCK.USER_PASSWORD;

IF UNAME IS NOT NULL AND UPWD IS NOT NULL THEN 
  PL_ID := GET_PARAMETER_LIST('PLIST');
    
    IF NOT ID_NULL(PL_ID) THEN
       DESTROY_PARAMETER_LIST('PLIST');
    END IF;
  PL_ID := CREATE_PARAMETER_LIST('PLIST');
	
    IF NOT ID_NULL(PL_ID) THEN
      ADD_PARAMETER(PL_ID,'USER_NAMES',TEXT_PARAMETER,PNAME);
    END IF;

  CALL_FORM('.\FORMS\FRM_MAIN_MENU.fmx',HIDE,DO_REPLACE,NO_QUERY_ONLY,PL_ID );
  EXIT_FORM(NO_VALIDATE);		


END IF;

EXCEPTION
  WHEN NO_DATA_FOUND THEN 
    SET_ALERT_PROPERTY('COMMON_ALRT', ALERT_MESSAGE_TEXT, 'User Name or Password not Correct...!');
    ALRT := SHOW_ALERT('COMMON_ALRT');
	IF ALRT = ALERT_BUTTON1 THEN
	   :USER_NAME     := NULL;
	   :USER_PASSWORD := NULL;
	   GO_ITEM('USER_NAME');
	END IF;	
END;

[Updated on: Wed, 03 February 2010 08:02]

Report message to a moderator

Re: call from through menu with parameter [message #442248 is a reply to message #441858] Fri, 05 February 2010 23:54 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
U can use GLOBAL variable to keep a value winthin a session.

Tamzidul Amin.
Re: call from through menu with parameter [message #442249 is a reply to message #442248] Sat, 06 February 2010 00:51 Go to previous messageGo to next message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

Thanks for your reply i done it... after 15 min of my post...
thanks for your reply..
Re: call from through menu with parameter [message #478895 is a reply to message #441858] Wed, 13 October 2010 05:35 Go to previous messageGo to next message
zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan
Junior Member
ho di u solve this problem

share with others

Re: call from through menu with parameter [message #478905 is a reply to message #442249] Wed, 13 October 2010 07:13 Go to previous messageGo to next message
nagpalgggmailcom
Messages: 14
Registered: August 2010
Location: Bangalore
Junior Member
Hey.

Please pass your comment how you completed?

Regards,
Nagpal

[Updated on: Wed, 13 October 2010 07:14]

Report message to a moderator

Re: call from through menu with parameter [message #478915 is a reply to message #478905] Wed, 13 October 2010 09:58 Go to previous message
allianz2010
Messages: 101
Registered: October 2009
Location: Pakistan
Senior Member

Quote:
tamzidulamin
U can use GLOBAL variable to keep a value winthin a session.

Tamzidul Amin.

why u use this method... for which purpose...

regards..
waqas mehmood
Previous Topic: oracle.forms.webutil.cApi.CApiFunctions bean not found.WEBUTIL_C_API.REBIND_PARAMETER will not work
Next Topic: Items on tab page getting invisible
Goto Forum:
  


Current Time: Sat Dec 03 08:15:31 CST 2016

Total time taken to generate the page: 0.17303 seconds