8.Properties pallet

While in the Layout Editor, double clicking on an object(or click on Ticket no and press F4 button) will bring up that object’s properties. Optionally, clicking on an object with the right mouse button will bring up a small menu which has the Properties menu item on it. The following figure shows the properties for the Ticket_no item.

Each type of object has a slightly different set of properties. For example, double clicking on the Ticket_Booking data block in the Object Navigator (pull down the Tools menu and choose Object Navigator) will display that data block’s properties.

Some properties of interest for a data block include:

• WHERE Clause – specify a WHERE clause to filter the selection of rows from the base table.
• ORDER BY Clause – specify an ORDER BY clause to alter the displayed order of the records.
• Delete Allowed, Insert Allowed, Query Allowed and Update Allowed – toggle these properties to allow or prevent the action. For example, setting Delete Allowed to FALSE prevents users from deleting records from the corresponding base table using this form.
• There are numerous other properties that affect the fonts, colors, size and position of objects in the block.

Property pallets are based on the node we have selected,its different for

• Form
• Trigger
• Block 
• Item
• Canvas
• Window
• Frame
• Parameter
• Program Units

Understanding properties is a major responsibility of a developer to determine and examine the working of oracle forms in all the cases.

Previous Next