Re: firign sequence of triggers in forms
Date: Tue, 23 Apr 2002 15:03:25 GMT
Message-ID: <3CC577AD.53DA046F_at_exesolutions.com>
The way I have done it is to create a small table. Put an insert statement into a bunch of triggers like this:
BEGIN
INSERT INTO test VALUES ('object_name-trigger_name');
END;
Run the form and look at the table. If you create a sequence and put an
insert table on the trigger you can guarantee yourself the ability to
retrieve the table rows in the order in which they were inserted.
There may be a better way, and I'm open to hearing about it, but I haven't met it yet.
Daniel Morgan
Adam Hapworth wrote:
> I am looking for a good tutorial or reading of how the firing order of
> triggers in forms goes. I was also wondering if there are any tools
> out there that would map the firing order of "my" (inherited from
> previous developer) form so I can better debug and update the current
> form.
>
> Thanks
> Adam
Received on Tue Apr 23 2002 - 17:03:25 CEST