|
|
|
|
| sequence of trigers that fired [message #135381 is a reply to message #134983] |
Wed, 31 August 2005 06:46   |
joemelvin
Messages: 10
Registered: August 2005
Location: tamil nadu
|
Junior Member |
|
|
hi
i have faced a question in an interview ?
when ur navigating from one block to other block what will be the sequence of triggers that got fired? list out one by one triggers.
|
|
|
|
| Re: sequence of trigers that fired [message #135509 is a reply to message #135381] |
Wed, 31 August 2005 18:57 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
There is the common answer and the nasty-person answer.
Try searching this forum for 'order' or maybe 'sequence'. There will be a quite a few answers but the answer should be in there somewhere.
Common: If a change has been made all the On- triggers, then all the Post- triggers in old item, old record, old block, form order and then all the Pre- triggers in form, new block, new record, new item order.
Nasty-person answer: Assuming one row added, one row changed, and one row deleted, and keeping in mind the 'common' answer, work through a mental list comprising 4 or 5 items each with various triggers including at least one 'user named' trigger, reel off (ie speak quickly, without taking a breath) all the triggers BY OBJECT AND NAME. You should be able to get out all the 'old block' triggers (about 20 of them) in your first breath, then reel off the new block triggers in a very long second breath, then in the third breath say, 'if there is a relationship betwenn the two blocks then the answer would also include the relationship based population triggers and rell them off'. In your fourth breath say 'and if that block had a relationship then ...' and repeat the third list of triggers. As a final piece say 'and of course all the When-Validate-Item triggers and associated timers would also have to be considered'.
I do really dislike this question ... just say 'Post- triggers and Pre- triggers and relationships are fired, but there are many other less widely used ones as well.'
David
[Updated on: Tue, 06 September 2005 20:27] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
