Home » Developer & Programmer » Forms » A beginner with Oracle forms
A beginner with Oracle forms [message #413030] Tue, 14 July 2009 01:29 Go to next message
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 #413052 is a reply to message #413030] Tue, 14 July 2009 03:31 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
meim wrote on Tue, 14 July 2009 08:29
so, what is suggested to be the best way to grab oracle forms and specifically understand the way of triggers functionality?

In my opinion, writing respectable number of forms and triggers will help tremendeously.
Re: A beginner with Oracle forms [message #413140 is a reply to message #413030] Tue, 14 July 2009 09:59 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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)
Re: A beginner with Oracle forms [message #413219 is a reply to message #413140] Tue, 14 July 2009 16:45 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
djbabu wrote on Tue, 14 July 2009 16:59
guys, sorry for the format... should have attached as word file...

No, because some people can not (and some do not want to) download .DOC files from an unknown sources due to potentially dangerous contents (macro viruses, for example).

What you should have done was to post a link to that document, not its contents. Did you write it? What about copyright? OraFAQ doesn't host materials protected by copyright (so, unless you prove it differently, your message might be censored).
icon14.gif  Re: A beginner with Oracle forms [message #413238 is a reply to message #413219] Tue, 14 July 2009 23:19 Go to previous message
shaz
Messages: 182
Registered: June 2009
Senior Member
Good content Djbabu Smile Smile Smile
Previous Topic: Form 6i: Read text file va
Next Topic: How can I set the moving text on form
Goto Forum:
  


Current Time: Fri Dec 09 03:50:16 CST 2016

Total time taken to generate the page: 0.24875 seconds