I have an application that has 4 blocks (Block 1 - Block 4). When I
"commit" changes, are they performed on these blocks in the order they
are listed in the object navigator? For ex., when a commit is issued,
is Block 1 inserted/updated/etc. before Block 2, etc.?
If I use a form-level pre-insert trigger, doesn't that fire each time a
row is inserted into ANY of the 4 tables represented? I had
considered using a form-level pre-insert trigger, but some of the code
in the trigger would be specific to individual blocks. Thus, I didn't
know how to qualify "if inserting Block 1 do this"; so, I have
pre-insert triggers at the block level.
But this is also causing problems as there is some data in Block 3 that
needs to be saved into Block 1 as well. But if the data in Block 3 is
not set until it is inserted, it will not be available for the Block 1
pre-insert trigger.
Is there a way to have the blocks display in one sequence, but have
them save in another sequence?
Please post replies to the newsgroup and/or me directly at
powell_at_clemson.edu.
Thanks in advance.
--JP
p.s.
I REALLY appreciate the replies individuals have sent to my prior
questions; they have been very helpful!