OraFAQ Forum: Forms » How To Call Form Through Another Fome(Help)

Home » Developer & Programmer » Forms » How To Call Form Through Another Fome(Help)

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

How To Call Form Through Another Fome(Help) [message #252216]

Wed, 18 July 2007 02:55

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

Report message to a moderator

Re: How To Call Form Through Another Fome(Help) [message #252228 is a reply to message #252216]

Wed, 18 July 2007 03:59

bahubcd
Messages: 40
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.

Report message to a moderator

Re: How To Call Form Through Another Fome(Help) [message #252291 is a reply to message #252216]

Wed, 18 July 2007 08:56

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

Report message to a moderator

Re: How To Call Form Through Another Fome(Help) [message #252459 is a reply to message #252291]

Wed, 18 July 2007 22:03

bahubcd
Messages: 40
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

Report message to a moderator

Re: How To Call Form Through Another Fome(Help) [message #252481 is a reply to message #252216]

Thu, 19 July 2007 00:17

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 12:26:25 CST 2024