Tutorial for Designer/2000
In this lesson you will learn:
- What is Developer/2000
- Tools provided by Developer/2000 to create Forms and Reports
- How to log on to Developer/2000
- Create your first block and form based on your Student table
What Is Developer/2000?
Developer/2000 is an Oracle tool that helps you to create forms and reports based on the tables that you have created using Designer/2000. You can use Developer/2000 to:
- Design and customize your forms and reports.
- Add various functionality, like radio buttons, combo boxes, and list of values to make your forms and reports more user friendly.
- Write triggers on your objects to add functionality to them and capture errors.
Tools Provided By Oracle Developer/2000
Oracle Developer/2000 provides four tools:
- Object Navigator: In this tool you can view all your objects, add new objects and name/rename your objects.
- Layout Editor: This tool helps you design your forms and reports and add various objects to them like push buttons and list boxes.
- PL/SQL Editor: This is the tool that is used to write all the codes for the triggers, procedures or functions.
- Menu Editor: This tool will help you create a customized menu that can be attached to your form or report.
Logging On to Developer/2000
- To log on to Developer/2000, go to Start Developer R2.1 and select Form Builder (See Figure 8.1)
Figure 8.1: The Start Menu for Logging in to Developer/2000
- Immediately, you will see the window for Developer/2000 Form Builder for Windows 95/NT with the sub-window for Welcome to Form Builder. (See Figure 8.2)
Figure 8.2: The Form Builder window
- Select 'Use the Datablock Wizard' and click OK--This is the easiest method to design a new form.
- You will now see the Welcome to the Datablock Wizard Window. Click Next to proceed. (See Figure 8.3)
Figure 8.3: Welcome to Datablock Wizard Window
- You will now see the window for the Datablock Wizard. Select Table or View as in the figure and click Next. (See Figure 8.4)
Figure 8.4: The Datablock Wizard Window
- You will now see the window that prompts you to select a table or a view--your form will be created based on this selection. Since no table or view is being shown, click on browse to look at the list of tables and views in your database. (See Figure 8.5)
Figure 8.5: The window for selecting the base table
- Once you click browse, the connect window will appear. Type in your username, password and database to connect to the database. (See Figure 8.6)
Figure 8.6: The Connect String Window
(We typed "server" in the Database field because our data resides on a central server. If your data resides on your personal hard drive, this field can be blank.)
On to page two
Page 1, Page 2, Page 3 / Back to the tutorial index.
About the Book
©1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to email@example.com