Re: FORMS 4.5 problem "WHEN-VALIDATE-ITEM"

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/09/11
Message-ID: <5v7t1d$h6n_at_info.csufresno.edu>#1/1

When-Validate-Item triggers run multiple times if you write a process that runs from something like a when-button-pressed or a key-... trigger, and your process attempts to navigate to a different item, row or block. Also you may have coded a Validate() statement somewhere in the process. To prevent the WVI trigger from running twice, you should put the following code after any GO_... commands that might be causing the problem:

  GO_Item('ANOTHER.ITEM'); --(or Go_Block, Next_Record, etc.)   If not form_success then
    Raise Form_Trigger_Failure;
  End if;

If you can't find the problem, you could add No_Acknowledge to your Message command (but I recommend finding the problem).

Regards,
Steve Cosner

---

http://members.aol.com/stevec5088 Download QA, a dynamic data utility form-- Quick display and update access to any table

In article <01bcbdde$922ddd80$136465cf_at_paul>, Joe Strano <jstrano_at_dulcian.com> wrote:
>I've encountered un-expected problems with WHEN-VALIDATE-ITEM triggers as
>well. As best as I can tell, this trigger fires
>whenever you leave the block, even if you haven't changed the item. It's
>possible that raise form_trigger_failure is moving the
>cursor out of the block, therefore firing the trigger again.
>
>Joe Strano
>Dulcian, Inc.
>
>X <X_at_X.PT> wrote in article <01bcbdda$1d1ab120$8f61a8c0_at_wspc2883>...
>> I have a form with a master detail relation, and in a text item a have a
>> trigger
>> when validate item with a code something like that:
>> ...
>> if :block.item > 10 then
>> message('error');
>> raise form_trigger_failure;
>> end if;
>> ...
>>
>> supose if block.item>10 the trigger fires 2 times or more.
>> I don't know if this is a Oracle BUG or there is a problem in my program.
>> Can anyone help me.
>>
>> Luis Santos
>> e-mail: l-miguel-santos_at_telecom.pt
>>
Received on Thu Sep 11 1997 - 00:00:00 CEST