OraFAQ Forum: Forms » How to pass values of current record as parameters to next form?

Home » Developer & Programmer » Forms » How to pass values of current record as parameters to next form? (Forms6i)

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

How to pass values of current record as parameters to next form? [message #378640]

Wed, 31 December 2008 03:22

adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo

Member

Hello everybody.
I faced with next problem: - how to pass values of current record as parameters to the next form ?
For example (see pic), when I double click on cell with value Adnan, i need to pass values (2,Adnan,manager), something like this:

DECLARE
  p ParamList;
BEGIN
  IF NOT Id_Null(Get_Parameter_List('OVJER_RN')) THEN
    Destroy_Parameter_List('OVJER_RN');
  END IF;
  p := Create_Parameter_List('OVJER_RN');
  Add_Parameter(p,'one',TEXT_PARAMETER,:empno);
  Add_Parameter(p,'two',TEXT_PARAMETER,:ename);    
  Add_Parameter(p,'three',TEXT_PARAMETER,:job);
 Open_Form(getpath||'RPF_odob_izmjena_rn',ACTIVATE,NO_SESSION,p);
  Destroy_Parameter_List('OVJER_RN');
END;

Thx in advance.