Window : 1) Model : we can not resize,minimize
2) Model Less window : User Friendley we can esiley
navigate other forms and minimize and maximize
Default : Model less Window
If we want to make it model window Goto Window
propeties : Model = Yes
canvases : 5
Content (Default)
Stacked
Horizontal Toolbar
Vertical Toolbar
TAB Pages
Proprty : Type = Content
Datablock : Databae Datablock : Select Data from table
Control Datablock : Without table
Database Datablock : Yes
Record Groups :
A record group is an internal Form Builder data structure
that has a column/row framework similar to a database table
Static : Enter the values manuvally
Query based : based on the select statment get the values
Non-Query based : Change the values dynamically.
LOV : List of Value which will be used to provide the list of values
in the fields user can select the value from the list.
Without Record group we can not create LOV.
Once LOV is created it will be attached to the field by selecting
the property called 'List Of Values'
Note : CREATE_GROUP by using this procedure we can create the Record
group dynamically.
Property Classes Visuval Attributes
1)Group of Properties 1)Group of Look and Feel properties
Font,Color,Size.....
2)We can not change dynamically 2)Visuval attributes can be changed
SET_VA_PROPERTY Procedure
3)We can define the Triggers for 3)We can not define
Property Class
Note : If same property given in both Property Class and Visuval
Attribute then Visuval Attribute will take the High priority.
Popup Menu : Will be created To populate group of menu options
when we select the Right click option.
Once popup is created then it will be assigned to field or CAnvas.
Alerts : Alerts are nothing but Messages which will be used to display
message boxes based on the user input we can change the Form
execution.
Triggers Levels :
Form Level
Data Block Level
Record Level
Item Level
Form Level : it Will be executed once for the entire Form.
Block Level : It Will be executed when we enter into the datablock.
Record level : It Will be executed for every reccord.
Item Level : It Will be executed for the Perticular Item.
Types Of Triggers:
1)When Triigers
2)Transactional Triggers
3)VAlidation Triggers
4)Query Time Triggers
5)On Triggers
6)Pre Triggers
7)Post Triggers
8)Navigational Triggers
9)Master Detail Triggers
10)Mouse Event Triggers
11)Key Triggers.
WHEN Triggers : WHEN-BUTTON-PRESSED
WHEN-WINDOW-CLOSED
WHEN-VALIDATE-ITEM
WHEN-VALIDATE-RECORD
WHEN-NEW-FORM-INSTANCE
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-ITEM-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
WHEN-MOUSE-CLICK
WHEN-MOUSE-DOUBLECLICK
WHEN-VALIDATE-RECORD : when user change the value in the fields then
it will be fired.
WHEN-NEW-RECORD-INSTANCE : When user create new record then it will be
fired.
Transactional Triggers: When user make some Transaction like
(INSERT,UPDATE,DELETE,SELECT,COMMIT,ROLLBACK,QUERY,CLOSE)
That time these triggers will be fired.
PRE-INSERT ON-INSERT POST-INSERT
PRE-UPDATE ON-UPDATE POST-UPDATE
PRE-DELETE ON-DELETE POST-DELETE
PRE-QUERY POST-QUERY.............
Validation Triggers :
WHEN-VALIDATE-ITEM - At any level
WHEN-VALIDATE-RECORD - At Block Level
When we change the value in the item (or) record it will be
fired.
Query Time Trigers:
Pre-Query : Trigger will be fired before query the data
Only once
Post-Query : Will be fired after query the data multiple times
for every record once it will be fired.
To Populate Non-Database Items.
Navigational Triggers :
When we navigate from one form to another form
from one datablock to another data block
from one record to another record these triggers
from one field to another field then these triggers
will be fired
Pre-block WHEN-NEW-BLOCK-INSTANCE POST-BLOCK
PRE-FORM WHEN-NEW-FORM-INSTANCE POST-FORM
PRE-RECORD WHEN-NEW-RECORD-INSTANCE POST-RECORD
PRE-TEXT-ITEM WHEN-NEW-ITEM-INSTANCE POST-TEXT-ITEM
Master Detail Triggers:
=======================
When we define the master detail relation ship between the Datablocks then
Master - Detail triggers will be created automatically.
Types Master Detail Relationships:
Non-Isolated : (Default) The master record cannot be deleted
if associated detail records exist
in the database
Isolated : The master record can be deleted,
but the associated detail records are not deleted
from the database.
Cascade : The master record can be deleted,
and any associated detail records are automatically
deleted from the database at commit time.
Master - Detail Triggers :
ON-CHECK-DELETE-MASTER (Non-Isolated)
ON-CLEAR-DETAILS
ON-POPULATE-DETAILS
pre-delete (Cascade)
Deptno :10
Dname : Accounting
Empno Ename Sal Deptno
4411 Scott 12500 10
4422 Ramu 12452 10
1545 Swetha 2365 10
Deferred : yes : We must place the cursor in the detail block
Automatic Query : yes : Data will be retrieved automatically in the detail
block.
Key Triggers:
Key-Fn : A Key-Fn trigger fires when an operator presses
the associated key
key-Others :A Key-Others trigger is associated with all keys
that can have key triggers associated with
them but are not currently defined by function key triggers
2) Model Less window : User Friendley we can esiley
navigate other forms and minimize and maximize
Default : Model less Window
If we want to make it model window Goto Window
propeties : Model = Yes
canvases : 5
Content (Default)
Stacked
Horizontal Toolbar
Vertical Toolbar
TAB Pages
Proprty : Type = Content
Datablock : Databae Datablock : Select Data from table
Control Datablock : Without table
Database Datablock : Yes
Record Groups :
A record group is an internal Form Builder data structure
that has a column/row framework similar to a database table
Static : Enter the values manuvally
Query based : based on the select statment get the values
Non-Query based : Change the values dynamically.
LOV : List of Value which will be used to provide the list of values
in the fields user can select the value from the list.
Without Record group we can not create LOV.
Once LOV is created it will be attached to the field by selecting
the property called 'List Of Values'
Note : CREATE_GROUP by using this procedure we can create the Record
group dynamically.
Property Classes Visuval Attributes
1)Group of Properties 1)Group of Look and Feel properties
Font,Color,Size.....
2)We can not change dynamically 2)Visuval attributes can be changed
SET_VA_PROPERTY Procedure
3)We can define the Triggers for 3)We can not define
Property Class
Note : If same property given in both Property Class and Visuval
Attribute then Visuval Attribute will take the High priority.
Popup Menu : Will be created To populate group of menu options
when we select the Right click option.
Once popup is created then it will be assigned to field or CAnvas.
Alerts : Alerts are nothing but Messages which will be used to display
message boxes based on the user input we can change the Form
execution.
Triggers Levels :
Form Level
Data Block Level
Record Level
Item Level
Form Level : it Will be executed once for the entire Form.
Block Level : It Will be executed when we enter into the datablock.
Record level : It Will be executed for every reccord.
Item Level : It Will be executed for the Perticular Item.
Types Of Triggers:
1)When Triigers
2)Transactional Triggers
3)VAlidation Triggers
4)Query Time Triggers
5)On Triggers
6)Pre Triggers
7)Post Triggers
8)Navigational Triggers
9)Master Detail Triggers
10)Mouse Event Triggers
11)Key Triggers.
WHEN Triggers : WHEN-BUTTON-PRESSED
WHEN-WINDOW-CLOSED
WHEN-VALIDATE-ITEM
WHEN-VALIDATE-RECORD
WHEN-NEW-FORM-INSTANCE
WHEN-NEW-RECORD-INSTANCE
WHEN-NEW-ITEM-INSTANCE
WHEN-NEW-BLOCK-INSTANCE
WHEN-MOUSE-CLICK
WHEN-MOUSE-DOUBLECLICK
WHEN-VALIDATE-RECORD : when user change the value in the fields then
it will be fired.
WHEN-NEW-RECORD-INSTANCE : When user create new record then it will be
fired.
Transactional Triggers: When user make some Transaction like
(INSERT,UPDATE,DELETE,SELECT,COMMIT,ROLLBACK,QUERY,CLOSE)
That time these triggers will be fired.
PRE-INSERT ON-INSERT POST-INSERT
PRE-UPDATE ON-UPDATE POST-UPDATE
PRE-DELETE ON-DELETE POST-DELETE
PRE-QUERY POST-QUERY.............
Validation Triggers :
WHEN-VALIDATE-ITEM - At any level
WHEN-VALIDATE-RECORD - At Block Level
When we change the value in the item (or) record it will be
fired.
Query Time Trigers:
Pre-Query : Trigger will be fired before query the data
Only once
Post-Query : Will be fired after query the data multiple times
for every record once it will be fired.
To Populate Non-Database Items.
Navigational Triggers :
When we navigate from one form to another form
from one datablock to another data block
from one record to another record these triggers
from one field to another field then these triggers
will be fired
Pre-block WHEN-NEW-BLOCK-INSTANCE POST-BLOCK
PRE-FORM WHEN-NEW-FORM-INSTANCE POST-FORM
PRE-RECORD WHEN-NEW-RECORD-INSTANCE POST-RECORD
PRE-TEXT-ITEM WHEN-NEW-ITEM-INSTANCE POST-TEXT-ITEM
Master Detail Triggers:
=======================
When we define the master detail relation ship between the Datablocks then
Master - Detail triggers will be created automatically.
Types Master Detail Relationships:
Non-Isolated : (Default) The master record cannot be deleted
if associated detail records exist
in the database
Isolated : The master record can be deleted,
but the associated detail records are not deleted
from the database.
Cascade : The master record can be deleted,
and any associated detail records are automatically
deleted from the database at commit time.
Master - Detail Triggers :
ON-CHECK-DELETE-MASTER (Non-Isolated)
ON-CLEAR-DETAILS
ON-POPULATE-DETAILS
pre-delete (Cascade)
Deptno :10
Dname : Accounting
Empno Ename Sal Deptno
4411 Scott 12500 10
4422 Ramu 12452 10
1545 Swetha 2365 10
Deferred : yes : We must place the cursor in the detail block
Automatic Query : yes : Data will be retrieved automatically in the detail
block.
Key Triggers:
Key-Fn : A Key-Fn trigger fires when an operator presses
the associated key
key-Others :A Key-Others trigger is associated with all keys
that can have key triggers associated with
them but are not currently defined by function key triggers
Properties :
Form Properties :
First Navigation datablock : If we have multiple datablocks in the form
which block you want to navigate first.
Datablock Properties :
DatabaseDatablock : If we set 'Yes' then it is a Database datablock
If we set 'No' then it is a Control datablock.
Maximum records displayed: we can specify how many records we can
display at a time in the CAnvas.
Query Datasource Name : Table Name
Trigger properties :
execution Hierarchy : To change the Triggers sequence firing in the
different order.
Item Properties :
Enabled :
Case Restriction
Required :
Database item
Insert Allowed
Pripmery Key
List of VAlues
Visuval Attributes.
To Change the Properties in the Runtime we will use
SET_ITEM_PROPERTY
set_Item_Property(Field Name,
Property Name,
Value);
set_Item_Property(DNO,
enabled,
YES);
window Propertis:
Model : No it means model less window
Yes it is Model window.
System Variables :
Will be used to find the form information dynamically like
form status,block name,item name,cursor field...........
Syntax: :SYSTEM.CURRENT_FORM
Go_block : To got the Perticular block.
Name_in functions:
Returns the value of the indicated variable.
No comments:
Post a Comment