Downloaded 94 times
Uploaded bySekhar Byna
Oracle Forms: Non input Items
The document discusses different types of non-input items that can be created in Oracle Forms including display items, calculated items, hierarchical tree items, image items, push buttons, and sound items. Display items display data but do not allow edits. Calculated items display values based on formulas or summaries. Hierarchical tree items allow the display of parent-child relationships. Image items display images stored in files or databases. Push buttons initiate actions rather than display data. Sound items play audio files but are not supported when running Forms applications in a web browser.
Oracle Forms: Non input Items
- 1. Part Working with NonInput Items http://ebiztechnics.blogspot.com
- 2. Objectives • Creating theNon input items such as – Display Item – Image Item – Calculated Item – Hierarchical Tree Item – Push Button – Sound Item http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 3. Items Input Items Non-InputItemsAllows user input Does not Allow user input • Text item • Check Box • Radio Group • List item Display Items Non Display Items • Display item • Image item • calculated item • Hierarchical Tree item etc. • Push Button • Sound Item http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 4. Display Items • Displayitems are similar to text items. • Display items does not allow to: – Be edited – Be navigated – Be queried – Accept user input • Display items allow: – Display data – Save memory http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 5. Image Items • Interfaceobject. • Used to display photographs and images – From file system – From Database which are stored in BLOB or Long Raw columns. – Supports various formats of Images like BMP, TIFF, PICT, GIF etc. http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 6. Image Item Properties •Image Format • Image Depth • Compression Quality • Display Quality • Show Palette • Sizing Style • Show Horizontal Scrollbar • Show Vertical Scrollbar http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 7. Calculated items • Theydisplay item values that are based on calculations. • They can not be edited. • They can be expressed as: – Formula – Summary http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 8. Calculated Items -Formula •Properties to be edited – Calculation Mode – Formula (Involves bind variables) Formula Item :emp.sal + nvl(:emp.comm,0) http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 9. Summary Item • Asummary is performed on values of a single item over all rows in a block. Properties Used – Calculation Mode – Summary Function – Summarized Block – Summarized Item http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 10. Rules for usingSummary Item • 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 http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 11.
- 12. Creating Hierarchical TreeItem Note: Trees must be in single row, single item blocks. http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 13. Hierarchical Tree Properties •Allow empty branches • Multi selection • Show lines • Show symbols • Record group • Data query Example for Data Query : SELECT 1,level,ename,null,empno FROM emp CONNECT BY PRIOR empno=mgr START WITH job=‘PRESIDENT’ Note: Do not terminate the query with semi colon. http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 14. Push Button • Interfacecontrol • Cannot display or represent data • Used to initiate an action • Display as: – Text button – Iconic Tooltip http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 15. Usage of PushButton • Use buttons to: – Move input focus – Invoke an editor – Display an LOV – Invoke another window – Commit data – Execute a query – Perform calculations http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 16. Properties of PushButton • Label • Mouse Navigate • Default Button • Iconic • Icon Filename • Tool tip • Tooltip Visual Attribute Group Note: .ico files are not supported in Web. Use .gif files for iconic buttons. http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 17. Sound Item • Interfacecontrol • Use to play and record sound: – From file system – From database——LONG RAW column or BLOB column • Sound Formats supported are: – AU, AIFF, AIFF-C, WAV Formats. Note: Sound items are not supported in Oracle Forms running in Web. http://ebiztechnics.blogspot.com Ph: +91 9632266314
- 18. Summary • Creation ofNon-input items – Display item – Calculated item – Hierarchical Tree item – Image Item – Push button – Sound item http://ebiztechnics.blogspot.com Ph: +91 9632266314
Editor's Notes
- #5 Note: Display items require less memory than text items. However, this is no longer as Significant, now that we have the Rendered property for text items.
- #6 Technical Note You can also populate an image item with a BFILE, but you will need to use DBMS_LOB to do so. Web Design Tip To reduce network traffic, limit the number of image items and background images in your Internet applications. Each time an image is required, it must be downloaded from the Application Server, images can not be cached. For example display a company logo in your application, you could include the Image in the HTML page that downloads at application startup rather than Retrieving the image from the database or the file system. The HTML page can be cached.
- #7 Note: Image items do not have a Data Type property. If you set an image item Database Item property to Yes, Form Builder understands that the data type is LONG RAW.
- #8 Note: A calculated item is read only. End users cannot insert or modify calculated items. You should, therefore, generally use display items as calculated items.
- #15 Web Design Tip Icon image files for iconic buttons must be in GIF or JPEG format (and not in ICO) Format) if your form application is going to be deployed on the web.