Home » Developer & Programmer » Forms » How to pass values of current record as parameters to next form? (Forms6i)
How to pass values of current record as parameters to next form? [message #378640] Wed, 31 December 2008 03:22 Go to next message
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.



  • Attachment: sample.JPG
    (Size: 15.42KB, Downloaded 90 times)
Re: How to pass values of current record as parameters to next form? [message #378648 is a reply to message #378640] Wed, 31 December 2008 03:53 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The code seems to be OK; what's the problem, actually?
Re: How to pass values of current record as parameters to next form? [message #378654 is a reply to message #378648] Wed, 31 December 2008 04:15 Go to previous message
adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo
Member
Littlefoot wrote on Wed, 31 December 2008 10:53
The code seems to be OK; what's the problem, actually?


I'm so sorry, it was my fault. You're right, everything is OK.

Thx anyway...
Previous Topic: Forms6i: write data in two or more Excel sheets
Next Topic: form error
Goto Forum:
  


Current Time: Thu Dec 08 14:13:04 CST 2016

Total time taken to generate the page: 0.10520 seconds