Jan 152015

Editors in Oracle Forms

Editors are used for special requirements such as: larger editing window, Search/Replace, cut, copy, paste etc.

Types of Editors

  • Default Editor
  • System Editor
  • User-Named Editor

Default Editor: The default editor provides standard editing features, including search/replace and cut, copy, and paste. The default editor is built into every form and is automatically available from every text item.

System Editor: If there is a system editor available, you can specify that Form Builder should use the current system editor, rather than the default editor.

User-Named Editor: Is a named object. You can specify editor attributes such as Window display size, Position and Title.

Built-in used for Editor:

SHOW-EDITOR: Is a built-in procedure, which accepts any editor name and takes some I/P string and returns modified O/P string.

EDIT_TEXTITEM: Needs the input focus to be in the text item before the built-in is executed.

LOV’s  in Oracle Forms

LOV (List of Values): An LOV is a scrollable popup window with either single or multi-column selection list.

Types of LOV:

Static LOV: Contains the predetermined values.

Dynamic LOV: Contains values that come at runtime.

LOV for Validation property of an item

When LOV for validation is set to true, Oracle forms compares the current value of the Text item to the values in the first column displayed in the LOV whenever the Validation event occurs. If the value in the text item matches one of the values in the First column of LOV, validation succeeds, the LOV is not displayed and the processing continues normally. If the value in the text item does not match one of the values in the first column of the LOV, Oracle forms displays the LOV and uses the Text item value as the search criteria to automatically reduce the list.

Built-in used to display the LOV are: SHOW_LOV (Function), LIST_VALUES (Procedure). Built-in that is used for setting the LOV properties: SET_LOV_PROPERTY, GET_LOV_PROPERTY.

Property Classes in Oracle Forms

A Property Class is a named object that contains a list of properties and their settings. There can be any number of properties in a property class and the properties in a class can apply to different types of objects. Property Class can be subclass in any number of modules. Property Class can have Triggers. You can define a Trigger in a property class when you want a form, block or item that you base on the class to inherit the trigger. When you define a trigger in a property class, the trigger appears in the object Navigator under the trigger node for the class, but does not appear under the trigger node for objects based on the class.

The various different types of Properties in Oracle Forms are:

Default Property: Is the default property of an object. Is denoted by a circle.

Changed Property: When changing the default property value of an object to some new value. Is denoted by a square.

Inherited Property: Is one that takes its value from the property class. It is displayed with an arrow to the left of the property name.

Variant Property: Changes a value of inherited property results to a variant property. It is displayed with a red cross over an arrow.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>