Showing posts with label D2K. Show all posts
Showing posts with label D2K. Show all posts

Sunday, October 19, 2008

Triggers created for Master Detaisl Relationship

* NON-ISOLATED (default)

on check delete master

on clear details

on populate details

* ISOLATED

on clear details

on populate details

* CASCADE

pre delete

on clear details

on populate details

Various Master Details Relationship

Non Isolated : The Master cannot be deleted when a child is existing

Isolated : The Master can be deleted when the child is existing

Cascading : The child gets deleted when the Master is deleted

Difference between Post Query and Pre Query.

A post query will fire for every row that is fetched but the pre query will fire only once

Wednesday, September 17, 2008

Sequence of trigger when form is opened & closed

Form Load

1. Pre-Logon From
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-Iten-Instance Item

--------------------------------------------
Form 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