Working in the Form Builder Environment

1. Working in the Form Builder Environment

2. Objectives After completing this lesson, you should be able to do the following: • Identify the main Form Builder executables • Identify the main components of Form Builder • Identify the main objects in a form module

3. Form Builder Key Features With Form Builder you can: • Insert, update, delete, and query data • Present data as text, sound, video, image, and ActiveX controls • Control forms across several windows and database transactions • Access Graphics and OLE2 applications • Use integrated menus • Send data to Report Builder

4. Form Builder Executables FormBuilder Form Compiler Forms Runtime Definitions Runfiles

5. Form Builder Module Types PL/SQL Library Object Library Menus Forms Libraries Oracle Developer Components ACTIVEX DDE OLE2 Other Data Sources Database

6. Blocks, Items, and Canvases Canvas 2 Canvas 1 Items Items Block B Block A

7. Navigation in a Block Canvas 2 Canvas 1

8. Data Blocks A B C Master Data Block 2 A B C D 3 Table 4 1 Detail Data Block 5 X Y Z X Y Z 6 Table

9. Data Blocks A B C Master Data Block 2 A B C D 3 Table 4 1 Detail Data Block 5 X Y Z X Y Z 6 Table

10. Forms and Data Blocks Block 1 Block 1 Block 1 Form C Block 2 Open Form Block 2 Block 1 Open Form Block 3 Form A Form B Multiple Form Modules Block 4 Single Form Module

11. Table Blocks Block(s) Column Item Item Trigger Trigger Frame Item Frame Item Canvas Canvas Program Program Item Item Units units Trigger Trigger Trigger Trigger Window Window Form Module Hierarchy Table Module Database Database Column

12. Summary • Form Builder allows screen-based querying, insertion, updating, and deletion of data. • Form Builder has powerful GUI and integration features. • Applications can consist of form modules, menu modules, and library documents.

13. Summary • Form modules consist of logical data blocks, which are logical owners of items. • Items in a data block can span several canvases.