ON-NEW-FIELD/WHEN-NEW-ITEM

From: Sean Stasica <v045101_at_procyon.stortek.com>
Date: Thu, 2 Jun 1994 21:59:14 GMT
Message-ID: <CqsIEr.23L_at_stortek.com>


Ok I have a dilemma, which Oracle tech support cannot seem to resolve either!

Situation:
You have two (or more) blocks in a form, and assign a ON-NEW-FIELD-INSTANCE trigger to a field in one of the blocks which basically goes to the other block, does some processing, and returns to the original block/field.

In Forms 3.0, using the ON-NEW-FIELD-INSTANCE trigger, it executes this trigger, and then returns to the original field for input.

In Forms 4.0, using the WHEN-NEW-ITEM-INSTANCE trigger, it executes this trigger, then upon returning to the original field, executes it again, ad infinitum!

In Forms 4.0, using the WHEN-NEW-BLOCK-INSTANCE trigger, it executes this trigger ONCE, then upon returning to the original block, field it returns for input.

Upon first glance into this problem, it seems like the 4.0 WNII trigger should work the same as the 3.0 ONFI trigger, which remembers that it already was on that field and doesn't need to execute that code again.

What tech support tells me is that the 4.0 WNII trigger works as defined. Ok, that's fine, if that's the case, but that would mean that there is a bug in the 4.0 WNBI trigger, and most likely the 3.0 ONFI trigger does not work as it should either.

I've been through three tech support people at Oracle, and I think I'm going to be handed off to another, as they can't understand what the discrepancy is. What does everyone think the true answer is to this problem? Is the Forms 4.0 WHEN-NEW-ITEM-INSTANCE trigger working as defined, and thus the Forms 3.0 ON-NEW-FIELD-INSTANCE and Forms 4.0 WHEN-NEW-BLOCK-INSTANCE trigger have a bug, or vice-versa?!?

I would write definitions directly from the books (2-73 to 2-75 in the 4.0 manuals, 3-97 in the processing manual for the "Return for Input" flowchart, and page 14-17 in my 3.0 manual) but I will leave it up to any interested parties to figure out where the discrepancies exist.

Received on Thu Jun 02 1994 - 23:59:14 CEST

Original text of this message