Header Ads Widget

Responsive Advertisement

Module 08: Creating LOVs and Editors

Creating LOVs and Editors

1. What are LOVs and Editors?

Lists of values (LOVs) and editors are objects in a form module that can associate with text items to enhance input. Each opens its own window when activated at run time. Both are defined at the form level.

LOV is a scrollable pop-up window that enables a user to pick the value of an item from a multicolumn static and dynamic list.

Editor which means that can use to support text items in any block of the form module and provide a larger area for text entry with search and replace capability.

2. Write down the benefits of LOV?

Dynamic:  The list entries can change to reflect change in source data.

Independent: The Designer can invoke an LOV from any text item, or from outside a text item if called programmatically.

Flexible: it can use the same LOV to support several items, if appropriate such as product_ID, Product_name.

Efficient: It can design LOVs to reuse data already loaded into the form. instead of accessing the database call

Useful: This is useful where data is relatively static

Simple technique: The user can reduce the lines displayed in the list by simple automatic reduction techniques or by search strings. 

3. How to create an LOV?

It is easy to create LOV with LOV wizard which perform the following steps:

    1. Select column

    2. Launch the LOV wizard. The welcome page appears. Click Next

    3. Click build SQL query >select data table>click include then close and select the column.

    4. Click check syntax>click Next and select LOV columns and specify the title, width and return value click Next.

5. Click next and specify rows for retrieving.

    1. Click next and select the items to which LOV should be attached.

    2. Click finish to complete the LOV creation process.

4. How to use an LOV at run time?

    1. Press the list of values key, select Edit > display list to invoke the LOV.

    2. Select an entry in the displayed list. We can enter characters to automatically reduce the list or enter a search string in the find field.

    3. Click OK to retrieve the line value

5. How to use an Editor at run time?

With the cursor in the text item to be edited, following these steps:

    1. Press the edit key, select edit>edit to invoke the attached editor.

    2. Edit the text in the editor window. Forms builder editors provide a search button that invokes an additional search and replace dialog box for manipulating text.

    3. Click OK to write your changes back to the text item.


Post a Comment