creating noninput items n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Creating Noninput Items PowerPoint Presentation
Download Presentation
Creating Noninput Items

Loading in 2 Seconds...

play fullscreen
1 / 32
susan-dejesus

Creating Noninput Items - PowerPoint PPT Presentation

103 Views
Download Presentation
Creating Noninput Items
An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Creating Noninput Items

  2. Objectives After completing this lesson, you should be able to do the following: • Identify item types that do not allow input • Create a display item • Create an image item • Create a sound item • Create a button • Create a calculated item • Create a hierarchical tree item

  3. Noninput Items Item types that do not accept direct user input include: • Display items • Image items • Sound items • Buttons • Calculated items • Hierarchical tree items

  4. Display Items • Display items are similar to text items. • Display items cannot: • Be edited • Be queried • Be navigated to • Accept user input • Display items can: • Display data • Conserve resources

  5. Creating a Display Item

  6. Image Items • Interface control • Use to display bitmapped images: • From file system—supported file type • From database—LONG RAW column

  7. Image File Formats Image files Image files JPG CALS Image item JPEG CALS Read Write TIFF GIF GIF TIFF JFIF BMP BMP JFIF PICT RAS RAS PICT TPIC TPIC

  8. Image-Specific Item Properties • Image Format • Image Depth • Compression Quality • Display Quality • Show Palette • Sizing Style • Show Horizontal Scrollbar • Show Vertical Scrollbar

  9. Image Manipulation Palette Select Zoom Pan Rotate

  10. Creating an Image Item

  11. Sound Items • Interface control • Use to play and record sound: • From file system—supported sound types • From database—LONG RAW column

  12. Slider Play Record Rewind Time Indicator Fast Forward Volume Sound Item Control

  13. Sound Types AIFF AIFF-C AU WAV

  14. Sound-Specific Item Properties • Sound Format • Audio Channels • Compress • Sound Quality • Show Play/Record/Rewind/Fast Forward/Volume Control/Time Indicator/Slider Button

  15. Creating a Sound Item

  16. Buttons • Interface control • Cannot display/represent data • Use to initiate an action • Display as: • Text button • Iconic

  17. Buttons • Use buttons to: • Move input focus • Display an LOV • Invoke an editor • Invoke another window • Commit data • Issue a query • Perform calculations

  18. Button-Specific Item Properties • Label • Mouse Navigate • Default Button • Iconic • Icon Filename • Tooltip • Tooltip Visual Attribute Group

  19. Tool Tip

  20. Creating a Button

  21. Calculated Items • They accept item values that are based on calculations. • They are read-only. • They can be expressed as: • Formula • Summary

  22. Calculation Modes • Formula • A calculated item value is the result of a horizontal calculation. • It involves bind variables. • Summary • A calculated item value is a vertical calculation. • A summary is performed on values of a single item over all rows in a block.

  23. Formula Calculation Mode Formula Summary Calculation Mode Summary Function Summarized Block Summarized Item Item Properties Specific to the Calculated Item

  24. Summary Functions • AVG • COUNT • MAX • MIN • STDDEV • SUM • VARIANCE

  25. Item Based on a Formula Order ORDERS NVL((:s_item.price * :s_item.quantity_shipped),0) Item Item Total Item id Product id Price Qty Shipped Formula item 1 200 1,000 5 2 120 480 4 50 3 9 450 25 4 3 75

  26. Rules for Formula Items • A formula item must not invoke restricted built-ins. • A formula item cannot execute any DML statements. • Do not terminate a PL/SQL expression with a semicolon. • Do not enter a complete PL/SQL statement in assignment expressions.

  27. Item Based on a Summary Order ORDERS Summarized item Item Item Total Item id Product id Price Qty Shipped 1 200 1,000 5 Summary item 2 120 480 4 50 3 9 450 25 4 3 75 Order Total 2,005

  28. Rules for Summary Items • Summary item must reside in: • The same block as the summarized item • A control block with Single Record property set to Yes • Summarized item must reside in: • A data block with Query All Records property or Precompute Summaries property set to Yes • A control block • Datatype of summary item must be Number, unless using MAX or MIN

  29. Creating a Hierarchical Tree

  30. Hierarchical Tree Properties • Allow empty branches • Multi selection • Show lines • Show symbols • Record group • Data query

  31. Summary • Display items • Image items • Sound items • Buttons • Calculated items • Hierarchical tree items

  32. Practice 9 Overview This practice covers the following topics: • Creating display items • Creating an image item • Creating iconic buttons • Creating calculated items: • Formula • Summary