developer d2k

Document Sample
developer d2k Powered By Docstoc
					         Developer 2000
   Forms and Reports (Oracle 9i)
             Vandana Janeja
                April 2004
         For : Database Systems
               22:198:603
           Prof. Vijay Atluri

   Adapted from material by Dr.Richard
Holowczak and Mahmoud Youssef Mohamed
ssh to pegasus, then ssh to penelope, password same as pegasus password
                       To create tables: initiate sqlplus from penelope




Sqlplus username: pegasususername@oradata2
Password if logging on first time is Spring2004
Change password after logging on first time using passw command
To be able to start forms initiate tunneling
You should have installed PC Xware before this
To start forms type: f90desm on penelope prompt
Change browser preferences using menu options:
Edit-> preferences-> runtime tab
Web Browser location /usr/local/bin/mozilla
After changing this you will have to close and start forms again for this to take effect
Connecting to database
Creating the data block using wizard
Browsing tables of existing user, if you have not
connected before you will be prompted to connect here
Selecting fields
Giving name to Data Block wizard
Layout Wizard is initiated to create a form layout
Selecting fields to be shown on the form
                         Changing width height of form components
                         This can be done in the layout editor also




Selecting type of form
Layout Editor
Saving form as .fmb file
For Other detailed notes please refer to:
http://www.pegasus.rutgers.edu/~youssefm/oracle/forms/index.html
And
http://cimic.rutgers.edu/~holowcza/oracle/

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:57
posted:4/6/2012
language:English
pages:21