Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I use go_item when I validate user input?

Re: How do I use go_item when I validate user input?

From: Fraser Boswell <Fraser.Boswell_at_spamme.ed.ac.uk>
Date: Tue, 22 Jun 1999 11:13:42 +0100
Message-ID: <376F61D6.805E4AB4@spamme.ed.ac.uk>


I remembered where I used this - it was when I was calculating a total per cent from all records, so it was a bit more complex. Geoff White is right, it's simpler than this, just use when-validate-item and raise form_trigger_failure

Fraser

Fraser Boswell wrote:

> You could try this:
> Set a global variable like :Global.check_now. When the form loads set it
> to 'FALSE'. Then when the post-text-item fires on the field to be
> validated set the check_now to 'TRUE'. At Block level set a
> When-new-item-instance trigger which starts
> IF :global.check_now = 'TRUE' THEN
> :global.check_now = 'FALSE';
> --validate here
> --if not validated then
> --message('not validated');
> --RAISE FORM_TRIGGER_FAILURE
> --end if
> END IF;
> This will work fine if you're only validating one field, more than one
> and it'd take more work. This IS a lot easier in VB but I suppose there
> are reasons for it.
>
> Fraser
>
> "Scotto!" wrote:
>
> > Hi,
> >
> > I know this is a restricted built-in and that Navigational
> > Triggers should not use this type, but it does work and
> > I want to use it. I just get the message that an illegal
> > use of a restricted procedure go_item.
> >
> > What I want to do is when I validate the input with the
> > when-validate trigger and the input is invalid, I want to
> > put the input focus on the invalid item. I know how to
> > do it in VB without error or message. But I cannot figure
> > out how to do it in Forms 4.5.
> >
> > Does anyone have a suggestion? Go_item does not
> > work in the next-item trigger either.
> >
> > I could temporarily suppress the message, but I should
> > not have to do that. If input is invalid, I should be able
> > to keep focus at the item.
> >
> > Thanks in advance,
> > Scott G.
> > IKEA North America
Received on Tue Jun 22 1999 - 05:13:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US