Introduction to Oracle 10 g Chapter 8 Understanding

Introduction to Oracle 10 g Chapter 8 Understanding and Using Forms Builder James Perry and Gerald Post 8 -1 © 2007 by Prentice Hall

Chapter Outline • • 2 Introduction to Forms Creating a Simple Main Form with the Forms Builder Modifying Forms Creating Tabular Forms and Sub Forms © 2007 by Prentice Hall

8. 1: The Agent form for Redwood Realty shows one agent at a time Sample forms 3 © 2007 by Prentice Hall

8. 2: The License Status form uses a grid layout to display multiple rows 4 © 2007 by Prentice Hall

8. 3: The Agent Contacts from combines a main form with a tabular form 5 © 2007 by Prentice Hall

8. 6 Web services architecture Overview of forms architecture on the Web Database server Compiled form Name. fmx Forms builder Name. fmb Developer 6 Forms and data Application server Javaenabled Web browser User © 2007 by Prentice Hall

8. 5 Design view of the structure of an Oracle form Items Object Navigator Tools 7 Canvas Property Palette © 2007 by Prentice Hall

8. 6 Choosing tables with the data block wizard Creating a form with the wizards The Browse button gives you the list of tables 8 © 2007 by Prentice Hall

8. 7 Choosing columns with the data block wizard 9 © 2007 by Prentice Hall

8. 8 Setting prompts and column widths in the layout wizard 10 © 2007 by Prentice Hall

8. 9 Choosing the number of records in the layout wizard 11 © 2007 by Prentice Hall

8. 10 Design of the initial Customer form 12 © 2007 by Prentice Hall

8. 11 First step of JInitiator setup Running the form 13 © 2007 by Prentice Hall

8. 12 Initial Customer form and form controls Save changes Close form 14 Execute Query Select prior or next record Add or delete records © 2007 by Prentice Hall

8. 13 Simple form query to find all customers with a last name beginning with the letter B Displaying data with form queries Enter Query Execute Query Cancel Query 15 © 2007 by Prentice Hall

8. 14 Rows filtered by the query 16 © 2007 by Prentice Hall

8. 15 Object alignment options The Layout Editor 17 © 2007 by Prentice Hall

8. 16 The object navigator 18 © 2007 by Prentice Hall

8. 17 Common form modifications Alignment options 19 © 2007 by Prentice Hall

8. 18 Adding a static image 20 © 2007 by Prentice Hall

8. 19 Design for the Listings form 21 © 2007 by Prentice Hall

8. 20 Loading an image to the database 22 © 2007 by Prentice Hall

Table 8. 1: Property changes for query lookup values Adding lookup columns with a List Of Values 23 Property New Value Name FIRSTNAME Prompt First Name Prompt Attachment Offset 7 Database Item Yes Column Name FIRSTNAME Primary Key No Query Only Yes © 2007 by Prentice Hall

8. 21 Choosing the return item with the List of Values wizard 24 © 2007 by Prentice Hall

8. 22 List of values for selecting the listing agent 25 © 2007 by Prentice Hall

8. 23 Changing an item type to Radio Group Adding Radio buttons 26 © 2007 by Prentice Hall

8. 24 Properties for the radio button 27 © 2007 by Prentice Hall

8. 25 Radio buttons on the form 28 © 2007 by Prentice Hall

8. 26 Setting the initial properties for a tabular form Creating tabular forms 29 © 2007 by Prentice Hall

8. 27 Tabular design for license status values 30 © 2007 by Prentice Hall

8. 28 Creating a relationship for a main/sub form Creating a main with sub form 31 © 2007 by Prentice Hall

8. 29 Initial main form and sub form design 32 © 2007 by Prentice Hall

Table 8. 2: Properties to change to add a display column 33 Property Value Name FIRSTNAME Enabled No Column Name FIRSTNAME Query Only Yes Prompt First Name © 2007 by Prentice Hall

Table 8. 3: Common entries format masks 34 Formatting Character Display Effect X Any character or digit. A Only alphabetic characters. 9 Only numbers. 0 Only numbers and displays leading zeros. YYYY Four digit year. MM Two digit year number. DD Day of month. © 2007 by Prentice Hall