Advanced Database Module 3

List of Values (LOV)

Scrollable pop-up window that enables a user to pick the value of an item from a multicolumn dynamic list

• Dynamic

• Independent

• Flexible

• Efficient

LOV Qualities

LOV Lamp

shows in the console area when a text item has LOV

Editor

Allows to view multiple lines of a text item simultaneously, search and replace text in it, and generally modify the value of an item from this separate window.

Record group

A column-and-row structure stored within Forms Runtime memory and is similar to the structure of a database table.

Input Items

A generic term for Forms Builder item types that accept user input.

Check Boxes

a two-state interface object that indicates whether a certain value is ON or OFF

List Items

An interface object that displays a predefined set of choices, each corresponding to a specific data value.

• Poplist

• Tlist

• Combo Box

3 list styles

Poplist

Appears as a field with an iconic button attached to the right

Tlist

Appears as a rectangular box that displays the list elements

Combo Box

Appears as a field with a down arrow next to its right

Radio Groups

An item where a set of radio buttons represents the possible values for the item.

Text Item

The default item type. An interface object with which you can query, insert, update, and delete data

• Converting an existing item into a text item

• Text Item tool in the Layout Editor

• Object Navigator

• Using the wizards

Ways to create text item