Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to create main menue for forms & reports

Status
Not open for further replies.

bilalch

Programmer
Sep 26, 2003
84
IR
hi dear fellows

i'm a beginner in oracle developer and i don't know much about pl/sql.
the problem here is that after i've created all the forms
and reports which i need. but now i want to create some main menue from where i logon to the oracle DB and, can call the forms or reports without logging on for each form and report separately, whatever on button click.
kindly write me in brief.
thanx.
 
You may call your forms from menu by CALL_FORM or OPEN_FORM built-ins. Just create some root form and attach menu calling other forms to it.

Regards, Dima
 

hi dear dima

many cardial thanks for ur reply to my question, but the main problem i've is that

1stly i'm a beginner and don't know how to pass the parameters to these functions as i've tried "call_form()" for the forms and from within the forms i've tried "run_product()" for the reports by giving the full path in parameters.but it generates error at compile time.
2ndly, the thing is that i want myself to keep from logging on to each report and form seperately. but i want
one interface window where i log-in and can navigate through forms and reports.

thanx
 
Can you specify versions and type of deployment? My suggestion was for client-server. In that case you need not apply credentials each time: moreover, you may call forms within the same Oracle session.

Regards, Dima
 
HI DEAR DIMA

THANX AGAIN FOR UR SUGGESTIONS.
I'M USING ORACLE 8 AND DEVELOPER 2000.

PLEASE WRITE IN DETAIL AS I DONT HAV MUCH KNOWLEDGE ABT IT

 
I'D SUGGEST YOU TO PRESS F1 AND READ DESCRIPTIONS OF THESE BUILT-INS.

Regards, Dima
 
hi dear dima
sorry for this but can u plz do it for me and tell me in detail as i tried it this way but didn't get much from this (F1)help.
 
No, I suppose that Online Help for these commands is exhaustive. Sorry.

Regards, Dima
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top