Home » Developer & Programmer » Forms » Sequence of insert-update-delete in Forms 6i
Sequence of insert-update-delete in Forms 6i [message #78591] Mon, 04 March 2002 23:59 Go to next message
gaurav pasrija
Messages: 5
Registered: March 2002
Junior Member
I wud like to know the sequence of on-insert, on-update, on-delete in multi-record block.
I tried it and the sequnce of trigger firing, I discovered is

on-delete
on-update
on-insert

irrespective of the sequence in whihc i did these operations. can anyone please tell me why these events happen in this order only.
or if I am wrong please correct it

thanx in advance.
Re: Sequence of insert-update-delete in Forms 6i [message #78593 is a reply to message #78591] Tue, 05 March 2002 00:16 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
yes u r correct.only when u commit/post in form , form goes through block by block as it appears in the designer and make changes to the database accordingly.
Re: Sequence of insert-update-delete in Forms 6i [message #78607 is a reply to message #78591] Tue, 05 March 2002 11:26 Go to previous message
ceycey
Messages: 22
Registered: February 2002
Junior Member
You can follow the events by adding message('deleted'),
message('inserted') and message('updated'). Sometimes I use these messages to focus on something.
Previous Topic: Re: Master Detail Delete
Next Topic: How do i switch from one canvas to another at runtime
Goto Forum:
  


Current Time: Sun Dec 22 22:53:11 CST 2024