Description: I. INTRODUCTION TO DEVELOPER/2000 FORMS. 1. Developing the First Form. The Equipment Tracking System. Creating the First Form. The Object Navigator. Creating a Data Block with the Data Block Wizard. The Layout Wizard. Adding a Detail Block. Compiling the Module. Summary. 2. Running the First Form. Running Modules Within the Form Builder. Developer/2000 Forms Runtime Window. Querying the Database. Normal Mode and Query Mode. Manipulating the Database. Transactions in Developer/2000 Forms. Multi-User Applications and Record Locking. What Is Missing in ETS? Summary. 3. Enhancing the First Form. Transforming the Form into a Tabbed Layout. Arranging Items in the Layout Editor. Enhancing the GUI Interface. Adding Calculated Items. Enhancing the Functionality of Applications with PL/SQL Code. Deploying the ETS Application. What Is the Rest of the Book About? Summary. II. FORMS DEVELOPER TOOLBOX. 4. Oracle Developer Form Builder. Overview of Oracle Developer. Components of Oracle Developer. Overview of the Form Builder. Working with Modules. Storing Modules in the Database. Summary. 5. Object Navigator. Accessing the Object Navigator. Components of Object Navigator. Form Builder Object Types and Object Instances. Getting Around Object Navigator. Manipulating Objects in Object Navigator. Different Views of Objects in Object Navigator. Customizing the Object Navigator. Summary. 6. Layout Editor. Accessing the Layout Editor. Components of the Layout Editor. Working with Objects in Layout Editor. Setting Visual Attributes in the Layout Editor. Customizing the Layout Editor. Customizing Color Palettes. Summary. 7. Property Palette, Menu Editor, and Object Editor. The Property Palette. Components of Property Palettes. Using the Property Palette. The Menu Editor. Components of Menu Editor. Using the Menu Editor. The Library Editor. Components of the Library Editor. Using the Library Editor. Summary. 8. RAD and Object Reusability. Overview of Rapid Application Development. Object Reuse in Oracle Developer. Object Groups. Property Classes. Visual Attribute Groups. Practical Examples. Oracle Designer Reusable Components. Summary. 9. Introduction to SQL. Brief History of SQL Language. Movie Rental Database. Categories of SQL Commands. Data Retrieval with SELECT. Expanding Queries with Set Operations. Data Manipulation Language Commands. SQL Functions. DUAL Table. Summary. 10. Introduction to PL/SQL. Overview of PL/SQL. Procedural Constructs of PL/SQL. Data Types and Variables. Cursors in PL/SQL. PL/SQL Program Units. Exception Handling. PL/SQL in Form Builder. The PL/SQL Editor. Summary. 11. Object-Relational Oracle8 and PL/SQL. Overview of the Object-Relational Technology. Object Types and Object Instances. Storing Objects in the Oracle8 Database. Collections. Summary. III. DEVELOPER FORMS OBJECTS. 12. Object-Oriented Analysis and Design. Movie Rental Database Problem Restated. Object-Oriented Terminology. Structured Design versus Object-Oriented Design. Designing the MRD Application. User Interface Design and Conventions. Summary. 13. Data Blocks, Frames, and Relations. Types of Blocks. Creating and Maintaining Data Blocks. Defining and Maintaining the Layout of Blocks. Maintaining Block Properties in the Form Builder. Maintaining Block Properties Programmatically. Frames. Relations. Blocks and Relations for the MRD Application. Summary. 14. Items and Data Items. Types of Items. Creating Items. Generic Properties of Items. Setting Properties of Items at Runtime. Validation of Items. Text Items and Display Items. Calculated Items. Events of Text Items. GUI Guidelines for Data Items. Data Items in the MRD Application. Summary. 15. GUI Control Items. Push Buttons. Radio Groups and Radio Buttons. Check Boxes. List Boxes. GUI Guidelines for Controls. Controls in the MRD Application. Summary. 16. Windows, Canvases, and Dialog Boxes. Properties of Windows. Developing MDI Applications with Form Builder. Alerts. Canvases. Canvas Use Cases. Windows and Dialog Boxes in the MRD Application. Summary. 17. Record Structures and Other Objects. Records in Form Builder Applications. Record Groups. Lists of Values. Text Editors. Parameters and Parameter Lists. Summary. 18. Menus and Toolbars. Form Builder Menus. Toolbars. Pop-up Menus. Summary. 19. PL/SQL Objects. Events and Triggers in Form Builder Applications. PL/SQL Libraries. Creating a Package for the MRD Application. Stored Program Units and Database Triggers. Oracle Designer Server API. Summary. IV. BUILDING INTEGRATED DEVELOPER APPLICATIONS. 20. Debugging. Accessing the Debugger. Components of the Debugger. Managing Debug Actions. Forms Runtime Diagnostics (FRD). Summary. 21. Creating Integrated Developer Applications. Creating Multiple-Form Applications. Integrating Tools with RUN_PRODUCT. Integrating Form Builder with Report Builder. Integrating Form Builder with Graphic Builder. Summary. 22. Developer Reusable Components. Overview of Developer Controls. Calendar Control. Hierarchy Browser Control. Wizard Control. Summary. 23. Managing Developer Projects. Overview of the Project Builder. Managing Projects with the Project Builder. Customizing the Project Builder. Delivering Projects. Summary. 24. Developer Forms for the Web. What Is the Network Computing Architecture? Developer Forms'' Three-Tier Architecture. Implementing Developer Forms on the Web. Special Considerations for Deploying Developer Forms on the Web. Summary. 25. Creating Forms with Designer. Modules in Designer. Structure of Modules. Working with Modules. Creating and Maintaining Module Elements. Module Wizards. Reusable Components. Summary. 26. Generating Designer Modules. Repository-Based Software Development. Maintaining Preferences. Object Class Libraries. Generator Templates. Designer Front-End Generators. Summary. V. EXTENDING DEVELOPER APPLICATIONS WITH MICROSOFT TECHNOLOGIES. 27. Dynamic Data Exchange. What Is DDE? DDE in Developer Tols. Examples of DDE with Form Builder. Summary. 28. COM-Based Technologies. What Is COM? OLE Documents Technology. In-Place Activation of Embedded Objects. Linking Objects in Form Builder. Linking and Embedding in the Layout Editor. Manipulating Compound Documents Programmatically. Summary. 29. Automation and ActiveX Controls. Automation. Automation in Form Builder. Software Components. ActiveX Controls. Summary. 30. Foreign Function Interface. Types of Foreign Functions. Sample Foreign Functions. User Exit Interface. PL/SQL Foreign Function Interface. Summary. Index.

Please Wait