| A beginner with Oracle forms [message #413030] |
Tue, 14 July 2009 01:29  |
meim
Messages: 35
Registered: July 2009
|
Member |
|
|
Hi,
am a beginner in building oracle forms. I did self study on that using oracle student guide.
However, I still can't see the whole things in one image.
so, what is suggested to be the best way to grab oracle forms and specifically understand the way of triggers functionality?
any articles/reference can be a good start ?
Or any suggestion of wht is the best way to learn forms
Thanks in advance
Regards,
Meim
[EDITED by LF: removed message formatting which resulted in unreadable, tiny font size]
[Updated on: Tue, 14 July 2009 03:29] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: A beginner with Oracle forms [message #413140 is a reply to message #413030] |
Tue, 14 July 2009 09:59  |
djbabu
Messages: 14
Registered: May 2009
|
Junior Member |
|
|
Introduction
This document lists the order in which triggers fire in Oracle Forms
o The first column, Action, describes the function to be performed (e.g. deleting a record).
o The second column, Trigger Firing Order, describes the order in which triggers fire after a
function is performed.
o The third column, Level, describes the level (form, block, item) at which the trigger fires.
This was accomplished by creating a form with all the triggers invoked. If a trigger could fire at all levels, it was included at all levels. Such a trigger fires at the lowest level at which it is defined.
Key triggers and triggers which fire via buttons or check boxes are not included.
This bulletin does not cover every contingency and covers only the most commonly used actions.
-------- ---------------------- --------
Action Trigger Firing Order --> Level
-------- ---------------------- --------
Runform
1. Pre-Logon --> Form
2. On-Logon --> Form
3. Post-Logon --> Form
4. Pre-Form --> Form
5. When-Create-Record --> Block
6. Pre-Block --> Block
7. Pre-Record --> Block
8. Pre-Text-Item --> Item
9. When-New-Form-Instance --> Form
10. When-New-Block-Instance --> Block
11. When-New-Record-Instance --> Block
12. When-New-Item-Instance --> Item
***********
Enter Query
1. Post-Text-Item --> Item
2. Post-Record --> Block
3. When-Clear-Block --> Block
4. When-New-Record-Instance --> Block
5. When-New-Item-Instance --> Item
Note: If you define the Key-ENTQRY trigger, this is the only trigger
which fires in an Enter Query situation.
*****************
Execute Query
After Enter Query
1. Pre-Query --> Block
2. Pre-Select --> Block
3. On-Select --> Block
4. When-Clear-Block --> Block
5. Post-Select --> Block
6. On-Fetch --> Block
7. On-Close --> Form
8. When-Clear-Block --> Block
Note: If you define the Key-EXEQRY trigger, this is the only trigger
which fires in an Execute Query situation.
*************
Execute Query
Without Enter Query
1. Post-Text-Item --> Block
2. Pre-Query --> Block
3. Pre-Select --> Block
4. On-Select --> Block
5. Post-Select --> Block
6. On-Fetch --> Block
7. On-Close --> Form
8. When_Create_Record --> Block
9. Pre-Record --> Block
10. Pre-Text-Item --> Item
11. When-New-Record-Instance --> Block
12. When-New-Item-Instance --> Item
****
Exit
1. Post-Text-Item --> Item
2. Post-Record --> Block
3. Post-Block --> Block
4. Post-Form --> Form
5. On-Rollback --> Form
6. Pre-Logout --> Form
7. On-Logout --> Form
8. Post-Logout --> Form
**************
Next Field and
Previous field
1. When-New-Item-Instance --> Item
***************
Next Record and
Previous Record
1. When-New-Record-Instance --> Block
2. When-New-Item-Instance --> Item
**************
Next Block and
Previous Block
1. Post-Text-Item --> Item
2. Post-Record --> Block
3. Post-Block --> Block
4. When-Create-Record --> Block
5. Pre-Block --> Block
6. Pre-Record --> Block
7. Pre-Text-Item --> Block
8. When-New-Block-Instance --> Block
9. When-New-Record-Instance --> Block
10. When-New-Item-Instance --> Form
*******************
Records Are Queried
1. Post-Query --> Block
2. Post-Change --> Block
3. Post-Change --> Item
4. Post-Change --> Block
5. Post-Change --> Form
Go back to Post-Query
NOTE: This cycle is repeated for each record retrieved.
**********************
No Records Are Queried
1. When-New-Record-Instance --> Block
2. When-New-Item-Instance --> Item
NOTE: To observe this Trigger Firing Order:
a. Enter a query.
b. Enter a nonexistent record.
c. Execute the query.
The two triggers listed above, the Enter Query triggers, and
the Execute Query triggers fire.
*************
Create Record
1. Post-Change --> Block
2. When-Validate-Item --> Block
3. Post-Text-Item --> Block
4. When-Validate-Record --> Block
5. Post-Record --> Block
6. Post-Block --> Block
7. On-Savepoint --> Form
8. Pre-Commit --> Form
9. Pre-Insert --> Block
10. On-Insert --> Form
11. Post-Insert --> Block
12. Post-Forms-Commit --> Form
13. On-Commit --> Form
14. Post-Database-Commit --> Form
15. Pre-Block --> Block
16. Pre-Record --> Block
17. Pre-Text-Item --> Block
18. When-New-Item-Instance --> Form
*************
Update Record
1. When-Database-Record --> Block
2. Post-Change --> Block
3. When-Validate-Item --> Block
4. Post-Text-Item --> Block
5. When-Validate-Record --> Block
6. Post-Record --> Block
7. Post-Block --> Block
8. On-Savepoint --> Form
9. Pre-Commit --> Form
10. Pre-Update --> Block
11. On-Update --> Block
12. Post-Update --> Block
13. Post-Forms-Commit --> Form
14. On-Commit --> Form
Here the transaction is complete and one record added.
15. Post-Database-Commit --> Form
16. Pre-Text-Item --> Block
17. When-New-Item-Instance --> Form
NOTE: To observe this Trigger Firing Order:
a. Execute a query.
b. Change a value.
c. Choose Action->Save from the menu.
d. Record the triggers from that point.
*************
Delete Record
1. On-Lock --> Block
2. When-Remove-Record --> Block
3. Post-Change --> Block
4. Post-Change --> Block
5. Post-Change --> Block
6. Post-Change --> Block
7. Post-Change --> Block
8. Post-Change --> Block
9. Post-Change --> Item
10. Post-Query --> Block
11. Post-Text-Item --> Block
12. Post-Record --> Block
13. Pre-Record --> Block
14. Pre-Text-Item --> Block
15. When-New-Record-Instance --> Block
16. When-New-Item-Instance --> Form
NOTE: To observe this Trigger Firing Order, delete a detail record.
---------
guys, sorry for the format... should have attached as word file...
meim, make sure you understand the above abt oracle forms. then it should be easy to catch up with form(triggers)
hope its useful..
djbabu
|
|
|
|
| Re: A beginner with Oracle forms [message #413152 is a reply to message #413030] |
Tue, 14 July 2009 11:12 |
meim
Messages: 35
Registered: July 2009
|
Member |
|
|
Littlefoot,
I made about 22 practices on building forms, where that reference i started with have a practice per chapter, but you still right practicing is the best to understand.
You know, sometime i think maybe bcz i did all that number of practices in short time didnt help me a lot, and i had to give each one more time to let the info resident on my head.
thanks a lot for your reply and advice (f)
djbabu,
This is really useful piece of info. I tried before to track the order of the trigger execution sequence by displaying messages while runtime to know which one goes first and so onel and this for sure will be a great help for me.
Thanks a lot for your reply and the doc (f)(f)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
