Transcript CH5_B
Introduction To Form Builder Part B Eyad Alshareef 1 Objectives Create data block from view Modify properties using Property Palette Text item properties Master-detail relationship Create master block first Specify relationship automatically or manually Eyad Alshareef 2 Creating a Form Based on a Database View View can be derived from one or more database tables Form based on a view allows you to display data from table(s) Form could be used to insert, update, or delete data if the view is a simple view only. Eyad Alshareef 3 Creating a Form Based on a Database View Similar to form based on table but read-only Eyad Alshareef 4 Modifying Properties Eyad Alshareef 5 Modifying Form Properties Eyad Alshareef 6 Guidelines For Configuring Form Windows 1. 2. 3. 4. 5. 6. Change the window title Allow user to minimize the window Do not allow the user to maximize the window Do not allow the user to resize the window Include horizontal and vertical scrollbars if items appear beyond window boundaries Make the form window fill the Forms Runtime window Eyad Alshareef 7 Configuring Form Windows Window Title Minimize/ Maximize buttons Eyad Alshareef Window size 8 Property Palette Eyad Alshareef 9 Modifying Form Properties Every form object has a Property Palette that allows you to configure form properties Property Nodes Property List Eyad Alshareef 10 Modifying Form Properties Use Property Palette of form object to modify desired properties To access: right click object, select Property Palette from menu Intersection mode modifies properties for multiple objects at the same time To open in intersection mode, select multiple objects before opening Property Palette Eyad Alshareef 11 Property Palette Eyad Alshareef 12 Intersection Property Palette Used to change property of several items to the same value Intersection/Union button appears as Name appears as ***** Eyad Alshareef 13 Frame Properties Update Layout Automatically Manually Frame items are automatically repositioned based on their order in the Data Blocks list when you move or resize a frame, or modify the form layout using the Layout Wizard in reentrant mode Items are automatically when layout is modified in Layout Wizard in reentrant mode Items are not repositioned if you move or resize the frame Locked Items are never automatically repositioned Eyad Alshareef 14 Modifying Text Item Properties Using the Property Palette Intersection mode Values appears as **** when objects have different values Text item properties Control how users enter data values How form displays data values Hint ToolTip Eyad Alshareef 15 Text item Appearance Properties Eyad Alshareef 16 Text Item Data Value Properties Eyad Alshareef 17 Text Item Database Properties Eyad Alshareef 18 Master-detail relationship Eyad Alshareef 19 Multiple-Table Forms Data block forms can display data from multiple tables that have a master-detail relationship Master record has multiple related detail records Examples: One ITEM record has multiple related INVENTORY records One CUSTOMER might have multiple CUST_ORDER records Eyad Alshareef 20 Creating the Detail Data Block Master-Detail page Auto-join feature of Data Block Wizard Create link manually Click Create Relationship Explicitly select related items Join Condition field syntax: detail_block.join_item = master_block.join_item Eyad Alshareef 21 Master-Detail Forms Master block Detail block Eyad Alshareef 22 Multiple Master-Detail Blocks Eyad Alshareef 23 Creating a Master-Detail Form Create the master block first Specify the relationship on the Data Block Wizard MasterDetail page of the detail block Eyad Alshareef 24 Complex Master-Detail Relationships A master block can have multiple detail blocks An item can be in multiple customer orders, and have multiple shipment records A detail block can be a master block in a second master-detail relationship A customer can have multiple CUST_ORDER records One CUST_ORDER record can have multiple ORDER_LINE records Eyad Alshareef 25 Complex Master-Detail Relationship Example Master Detail Detail Master Eyad Alshareef 26 Creating a form based on two linked tables In order to create a form based on 2 tables: Create a form similar to the STUDENT form we created (name it REGISTRATION) Create an additional data block using a wizard Establish master-detail relationship Eyad Alshareef 27 Creating a form based on two linked tables Follow the steps suggested by the wizard Eyad Alshareef 28 Creating a form based on two linked tables For the STUD_COURSE frame, select tabular layout, 4 records per page and a scrollbar. Eyad Alshareef 29 Compile and run your form Eyad Alshareef 30 Formatting Mask Eyad Alshareef 31 Formatting Text Items Specify desired format mask in text item Format Mask property If format mask makes value wider than text item Data Width property, data appears as ##### E.g: make the format mask for the empno field in the form builder: 99”- - “ 99 and make the data length for the field 4. Eyad Alshareef 32 Formatting Character Text Items Place embedded characters in double quotes Eyad Alshareef 33 Format Mask Examples Value Format Mask Result 7945 999 ### 7945 9999$ 7945$ 7945 99”-”99 79-45 34.28 99.9 34.3 34.28 99.999 34.280 SYSDATE Day-MON-YY Friday-NOV-06 Eyad Alshareef 34