Module 10: Creating Noninput Items

Creating Noninput Items

01. What is Non-input items?

Non-input items is a generic term for item type that do not accept direct user input.

02. What are Non-input items?

Non-input Items that can Display Data:

• Display items

• Image items

• Calculated items

• Hierarchical tree items

Non-input Items that Cannot Display Data:

• Push Buttons

03. What is Display Items? 

A display item is similar to a text item, except that it cannot be edited or navigated to at runtime. A display item is a read-only text box whose value must be fetched or assigned

04. What is an Image Item?

An image item is a special interface control that can store and display vector or scanned images. Just as text items store and display VARCHAR2, number, or date values, image items store and display images.

05. Write down the Image File Formats?

Forms Builder supports the following image formats:

06. What is a Push Button?

A push button is an interface object that you click to initiate an action. A push button cannot store or display values.

07. Write down the Push Button Styles?

Forms Builder supports two push button styles:

Text button: Displayed with a text label on the push button

Iconic button: Displayed with a bitmapped graphic on the push button, and often used in toolbars

08. What are push button action? Ans: We use push button to:

•  Move input focus

•  Display an LOV

•  Invoke an editor

•  Invoke another window

•  Commit data

•  Issue a query

•  Perform calculations

09. What are the rules for calculated Items Formulas?  

•  A formula items 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 expression.

10. What are the rules for summary items? Ans: # Summary items must reside in:

•  The same block as the summarized item.

•  A control block with the single record property set to yes.

# Summarized items must reside in:

•  A data block with the query all records property or the precompute summaries property set to yes.

•  A control block.

# Data type of summary item must be number, unless MAX or MIN.

11. What are Calculated Items?

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

-     Formula

-     Summary

12. What are Formula or Function?

•  Formula: A calculated item value is the result of a horizontal calculation & involves bind variables.

•  Summary: A calculated item value is a vertical calculation & is performed on values of a single item over all rows in a block.