Email Us : sunilkumark11@gmail.com
Free Training > SQL PL / SQL Forms Reports Oracle Applications

Forms

  1. Introduction of Oracle Forms
  2. Types of controls
  3. Visual Attributes
  4. Property class
  5. Constraints in forms
  6. Creating Database block Manually
  7. Master-detail relation
  8. Object Groups
  9. Object libraries
  10. Built_in subprograms used in form triggers
  11. Form Triggers
  12. Using button control
  13. Creating password screen
  14. Alerts
  15. Types of canvas
  16. Creating tables through forms
  17. Menus
  18. Record Groups
  19. Creating sub programs in forms
  20. Using Database triggers in forms
  21. PL/SQL Libraries
  22. Creating Database procedures and functions in forms.
  23. Creating data block using stored procedures
  24. Trapping errors
  25. Windows
< Previous Next >
 
Forms - Visual Attributes

Collection of predefined properties which can be applied to all items at once.
It holds properties which effect physical appearance  like color, font etc.

Types of Visual Attributes

  1. Common Attribute   --  Applicable to all items in a block.
  2. Prompt Attribute Applicable to prompts. ( Text before controls )
  3. Title Attribute Applicable to frame title only.

Creating Visual Attribute
Open existing form EMP_FORM.fmb
In Object navigator ( F3 )   Select Visual Attribute   Click on create button.
In the property palette, provide the following properties
General
Name VA1
Color
Foreground color Red
Background color Blue
Font
Font Name Arial
Font size 10
Font style Underline

Now, Assign the visual attribute to the items.

Go to Layout editor ( F2 ),
Select all the items ( Ctrl + A )  Point your cursor on ename field property palette
Visual Attributes
Visual Attribute group VA1
Save.
Program Compile module
Program Run Form
Click on execute query

Observe, the properties which we have applied to visual attribute group, is assigned in all the items at once easily. That is the advantage of visual attributes.

Note
The default visual attribute type is common.

 

Example of prompt visual attribute

Open existing form EMP_FORM.fmb
In Object navigator ( F3 )    Select Visual Attribute   Click on create button.
In the property palette, provide the following properties
General
Name PVA1
Visual Attribute type Prompt
Prompt Color
Prompt foreground color White
Prompt font
Prompt font name Tahoma
Prompt font size 14
Prompt font style Italic

Now, Assign the prompt visual attribute to Items.
Goo to object navigator ( F3)
In Data block EMP select multiple items ( 4 items)  using shift key  ( Empno, Ename , job, Mgr)
Bu holing shift key right click property palette Visual Attributes Prompt Visual Attribute group PVA1

Save.
Program Compile Module
Program Run Form

Observe, Prompt visual attribute group, is applicable only for prompt.

Example of Title visual attribute group
Open existing form EMP_FORM.fmb
In Object navigator ( F3 )   Select Visual Attribute   Click on create button.
In the property palette, provide the following properties
General
Name TVA1
Visual Attribute type Title
Frame title color
Frame title foreground color yellow
Title font
Frame title font name Book Antiqua
Frame title font size 18
Frame title font style Italic

Now, we need to assign title visual attribute to the frame
In Object navigator Canvas graphics Frame property palettle Visual Attributes Frame title visual attribute group TVA1

Save.
Program Compile Module

Program Run form

Observe, the properties are applicable to frame title.

 
< Previous Next >