• No results found

Oracle Form Builder v.6.0

N/A
N/A
Protected

Academic year: 2023

Share " Oracle Form Builder v.6.0"

Copied!
36
0
0

Loading.... (view fulltext now)

Full text

(1)

Forms -

Forms - An Overview of An Overview of Oracle Form Builder v.6.0

Oracle Form Builder v.6.0

 Abhishek

 Parag

(2)

Agenda Agenda

 What Is Oracle Form Builder?

 Forms Concepts - What is a Form?

 The Forms Application

 References

(3)

What Is Oracle Form Builder?

What Is Oracle Form Builder?

 Component of Oracle Developer/2000

– Forms

– Reports

– Graphics

 Application builder

 Event-driven applications

(4)

Forms - The Basic Idea Forms - The Basic Idea

 Are used to create applications to enter, access, change, or delete data from an Oracle database in an online, form-based environment.

 Forms provides many objects for developing an effective application module.

 Coupled with the concept of user extensibility,

Forms can be used to serve virtually every online

need in an Oracle database environment.

(5)

Forms Concepts The Big Forms Concepts The Big

Picture Picture

Triggers and/or

default processes

User actions Internal events

(6)

Forms Concepts Forms Concepts

 Events

 Processes

 Triggers

(7)

Forms Concepts Forms Concepts

 Events

– Things that happen

– External Events

User Interaction; Mouse, Keyboard, Menu – Internal Events

Timers

Processing steps for which triggers can be set

– Initiate Processes

(8)

Forms Concepts Forms Concepts

 Processes

– Pre-programmed default behaviour

– What Forms DOES, for example;

Navigation

Transaction Processing

Validation

Query Processing

Master-Detail coordination

– Series of Internal Events

(9)

Forms Concepts Forms Concepts

 Triggers

– Fired when Internal/External events occur

– Replace, supplement or initiate default processing

– Initiate “External” events, to make Forms behave as if user performed action

E.g. Simulate User key-press

(10)

Triggers Triggers

 Trigger

– Forms trigger

– Database trigger

(11)

Triggers Triggers

 Forms Trigger

– Fires in response to Forms Events

 Database Trigger

– Fires in response to Database Events

 THESE ARE COMPLETELY

INDEPENDENT OF EACH OTHER!!!

(12)

The Forms Application The Forms Application

Form Builder builds Forms, Menus and Libraries Application consists of at least one Form

Can also include one or more Menu and Library modules

Oracle provides default Menu

(13)

File Types File Types

 Forms Modules

.FMB; Forms Source

.FMX; Forms Executable

 Menu Modules

.MMB; Menu Source

.MMX; Menu Executable

 Libraries

.PLL; PL/SQL Source and Executables

.PLX; PL/SQL Executable Only

(14)

The Forms Application The Forms Application

What You See What You See

exit

enter

File Edit View Query Block Record Insert Help Whatever

Are you really sure you want to do this?

Canvas

View Control Item

Base- Table Item

Menu

Window

Yes No

(15)

The Forms Application The Forms Application

 What you see;

– Window

– Menu

– Canvas/View

– Items

Base-block items

Control-block items

(16)

Forms Components Forms Components

Highest Level of Hierarchy

- Forms - Menu

- Built-in Packages - Database Objects

(17)

Forms Components Forms Components

Windows

- Displays canvases.

- Form can have multiple windows.

- Modal; user must respond and dismiss window before doing anything in another window.

- Modeless; user can move to another window.

(18)

Forms Components Forms Components

Canvas-Views

- Visual element of Forms. This is how you display all those Items.

- Canvas; Background on which text and items are placed.

- View; Visible portion of canvas.

- Form can have multiple canvases.

- Canvases can be stacked, scrolled.

(19)

Forms Components Forms Components

Blocks

- Base-Table Block corresponds to Database Table; set of items

representing database table columns.

An ‘instance’ of a Base-Table Block corresponds to a Database Record.

- Control Block is usually a collection of control items (e.g. Buttons, Check- Boxes, Radio Groups), but can also

(20)

Forms Components Forms Components

Block Properties

(21)

Forms Components Forms Components

Items

- Base-Table Items are text items that correspond to Database

Columns. Forms creates them automatically.

- Control Items can be Buttons,

Check-Boxes, Radio Groups, Display Items (read-only text), Text Items (‘variables’), images, etc.

(22)

Forms Components Forms Components

Item Properties

(23)

Forms Components Forms Components

Visual Attributes

- Collection of display properties.

- Refer to Named Visual Attribute in Items to standardise appearance.

Change in NVA will affect all Items referring to it.

Property Classes

- Collection of ANY properties.

- When items refer to Property Class,

(24)

Forms Components Forms Components

Triggers

- At Form, Block or Item level - Lower level triggers fire before higher level triggers

- If same trigger-type occurs at different levels, only lowest will fire

(25)

Triggers Triggers

 Can be coded at Form, Block, and/or Item Level

 Some Triggers apply to multiple levels of hierarchy, others are specific

– When creating new trigger, List of Values presents list of appropriate triggers

 Each Trigger-type executes only once

(26)

Forms Component Forms Component

Alerts

- Window that displays message - Modal; User must respond

- One, two or three buttons - Three types;

- Stop (stop sign)

- Caution (exclamation) - Information (‘i’ symbol) - Use SHOW_ALERT built-in function

(27)

Forms Components Forms Components

LOVs

- Allows user to select from specific set of values.

- Displays Record Group.

(28)

Forms Components Forms Components

Editors

- Editor; simple text-editor dialog box for entering lines of text into Text Item.

- Can create editors with different appearances for different text fields.

(29)

Forms Components Forms Components

Parameters

- Used as a Form variable.

- Pass values between Forms.

(30)

Forms Components Forms Components

Program Units

- PL/SQL Procedures and Functions used in this Form.

(31)

Forms Components Forms Components

Attached Libraries, Libraries & Built-in Packages

- PL/SQL procedures and functions.

- Attached Library; Reference collected routines.

- Library; Maintain and reference collected routines.

(32)

Forms Components Forms Components

Object Groups

- Package reusable objects for later copying or reference.

- E.g. Your Form includes an alarm clock to wake the user after ten minutes inactivity. This includes Triggers, Procedures, a Window,

some graphics, etc. You can package these objects together to

conveniently include this functionality in other forms.

(33)

Tour of Form Builder Tour of Form Builder

 Starting forms

– Virtual session

 Connecting to the database

(34)

Client

What Is Forms Looking For What Is Forms Looking For

Forms Runtime

Forms Server

(Compiled Objects)

Database

Registry

FORMS_PATH

Connect

(35)

References References

 On-line help

 Oracle Developer/2000 Handbook (2nd. Ed.) – Robert J. Muller, Oracle Press

 Oracle technology network

(http://TechNet.Oracle.Com)

(36)

THANK YOU THANK YOU

References

Related documents

The mukhaja type of angika abhinaya involves the various movements of the major limbs, the head and the minor body parts such as eyes, nose, cheeks lower lip, chin,

methods with optimal oracle complexity (Chapter 2), a complete char- acterization of the relation between first order oracle complexity and curvature in the objective function

This is possible only if the entrepreneur is capable of effectively planning where he/she is, and where he/she would like to be and how? Some kind of a 'game plan' or a 'road map' is

⚫ Standard form of Boolean expression (Canonical Form): All Boolean expressions, regardless of their form, can be converted into either of two standard forms: the sum-of- products

As all Thaiyam are understood to be a visitation of the divine in the present, the ritual sequence facilitates this transformation, as it shifts from third person

Since ∧ is associative, commutative and absorbs multiple occurrences, a CNF formula may be referred as a set of clauses..

4) On the Oracle Application Express page, create a workspace for the existing database user HR, as shown in Figure... Creating a Simple Application.. • To create an application

Further, the SI shall ensure that the PoS devices, application software functionalities and any other components, equipment, peripherals involved in implementation