Home » Developer & Programmer » Forms » How To Call Form Through Another Fome(Help)
How To Call Form Through Another Fome(Help) [message #252216] Wed, 18 July 2007 02:55 Go to next message
hussienburhan
Messages: 28
Registered: July 2007
Junior Member
hi
im creating one form as master to insert data to a table
in thsi form i want put button named PRINT o i can call a form
that have text item and and enter some data in to call report through the second form

the second form i want call is form with fmx extension located in the same directory that the first form locate , i want also pass parameters to the second form parameters mean data in the text item in the first form plz help plz


Embarassed Embarassed Embarassed
Re: How To Call Form Through Another Fome(Help) [message #252228 is a reply to message #252216] Wed, 18 July 2007 03:59 Go to previous messageGo to next message
bahubcd
Messages: 36
Registered: July 2007
Location: Bangalore
Member
create parameters in the form which is being called.

Now in the calling(main) form do as below:

Eg:

PROCEDURE P_CALL_FORM IS

L_pl_id paramlist;
L_called_program VARCHAR2(20) := NULL;

BEGIN
P_destroy_parameter_list('MAIN_FORM');
L_pl_id := Create_Parameter_List('MAIN_FORM');



Add_Parameter(L_pl_id, 'PARAMETER_1', TEXT_PARAMETER, :DATA_BLOCK.FIELD_NAME_1);
L_called_program := 'SUB_FORM';


Open_Form (L_called_program,
ACTIVATE,
SESSION,
L_pl_id);





EXCEPTION
when FORM_TRIGGER_FAILURE then
raise;
when OTHERS then
emessage(SQLERRM);
raise FORM_TRIGGER_FAILURE;

END;

Revert back for any clarifications.
Re: How To Call Form Through Another Fome(Help) [message #252291 is a reply to message #252216] Wed, 18 July 2007 08:56 Go to previous messageGo to next message
hussienburhan
Messages: 28
Registered: July 2007
Junior Member
Thanks Mr bahubcd

I have Samll questions
main form and sub form will be my forms name right i mean with the name only or with extension also

for example i have Main Form Named Main.fmx and sub form named print.fmx i will put the name with extension or without

and this code i will write in the print button in the main form

thank you for helping
Re: How To Call Form Through Another Fome(Help) [message #252459 is a reply to message #252291] Wed, 18 July 2007 22:03 Go to previous messageGo to next message
bahubcd
Messages: 36
Registered: July 2007
Location: Bangalore
Member
The name of the form should be the file name without extension.

For Eg:

If main form's file name is main.fmb and sub forms name is sub.fmb then follow the below code.

L_pl_id := Create_Parameter_List('main');

L_called_program := 'sub';


The reason you dont need an extension is in fact that main.fmx will be calling sub.fmx. So no extension is needed

All the best Cool
Re: How To Call Form Through Another Fome(Help) [message #252481 is a reply to message #252216] Thu, 19 July 2007 00:17 Go to previous message
hussienburhan
Messages: 28
Registered: July 2007
Junior Member
Mr bahubcd
Its working im very happy thank you very much really ur master in oracle


can i have ur email so we can contact

Razz
Previous Topic: Help In Execution Query
Next Topic: TYPE OBJECTS in PLSQL
Goto Forum:
  


Current Time: Wed Dec 07 20:42:20 CST 2016

Total time taken to generate the page: 0.18576 seconds