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

[Quoted] 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 Wed Sep 10 1997 - 00:00:00 CEST