forms concepts
DESCRIPTION
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. Triggers. Trigger Forms trigger Database trigger. Triggers. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/1.jpg)
Forms ConceptsTriggers
– 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
![Page 2: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/2.jpg)
TriggersTrigger
– Forms trigger– Database trigger
![Page 3: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/3.jpg)
TriggersForms Trigger
– Fires in response to Forms EventsDatabase Trigger
– Fires in response to Database EventsTHESE ARE COMPLETELY
INDEPENDENT OF EACH OTHER!!!
![Page 4: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/4.jpg)
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
![Page 5: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/5.jpg)
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
![Page 6: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/6.jpg)
The Forms Application What You See
exitenter
File Edit View Query Block Record Insert Help Whatever
Are you really sure you want to do this?
Canvas
ViewControl Item
Base-TableItem
Menu
WindowYes No
![Page 7: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/7.jpg)
The Forms Application
What you see;– Window– Menu– Canvas/View– Items
Base-block items Control-block items
– Database records
![Page 8: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/8.jpg)
Forms ComponentsHighest Level of Hierarchy- Forms- Menu- Built-in Packages- Database Objects
![Page 9: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/9.jpg)
Forms ComponentsWindows- 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.
![Page 10: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/10.jpg)
Forms ComponentsCanvas-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.
![Page 11: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/11.jpg)
Forms ComponentsBlocks- 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 be collection of Display Items (read-only text), Text Items (‘variables’), images, etc.
![Page 12: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/12.jpg)
Forms ComponentsBlock Properties
![Page 13: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/13.jpg)
Forms ComponentsItems- 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.
![Page 14: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/14.jpg)
Forms ComponentsItem Properties
![Page 15: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/15.jpg)
Forms ComponentsVisual 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, only properties that make sense for that item will be used.
![Page 16: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/16.jpg)
Forms ComponentsTriggers- 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
![Page 17: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/17.jpg)
TriggersCan be coded at Form, Block, and/or Item
LevelSome Triggers apply to multiple levels of
hierarchy, others are specific– When creating new trigger, List of Values
presents list of appropriate triggersEach Trigger-type executes only onceLowest level Triggers fired first
![Page 18: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/18.jpg)
Forms ComponentAlerts- 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
![Page 19: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/19.jpg)
Forms ComponentsLOVs- Allows user to select from specific set of values.- Displays Record Group.
![Page 20: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/20.jpg)
Forms ComponentsEditors- Editor; simple text-editor dialog box for entering lines of text into Text Item.- Can create editors with different appearances for different text fields.
![Page 21: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/21.jpg)
Forms ComponentsParameters- Used as a Form variable. - Pass values between Forms.
![Page 22: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/22.jpg)
Forms ComponentsProgram Units- PL/SQL Procedures and Functions used in this Form.
![Page 23: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/23.jpg)
Forms ComponentsAttached Libraries, Libraries & Built-in Packages- PL/SQL procedures and functions.- Attached Library; Reference collected routines.- Library; Maintain and reference collected routines.- Built-in Packages; Oracle supplied procedure and functions.
![Page 24: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/24.jpg)
Forms ComponentsObject 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.
![Page 25: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/25.jpg)
Tour of Form Builder
Starting forms– Virtual session
Connecting to the database
![Page 26: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/26.jpg)
Client
What Is Forms Looking For
FormsRuntime
FormsServer
(Compiled Objects)
Database
RegistryFORMS_PATHConnect
![Page 27: Forms Concepts](https://reader035.vdocuments.us/reader035/viewer/2022070420/56815ee1550346895dcd872c/html5/thumbnails/27.jpg)
THANK YOU