Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I use go_item when I validate user input?
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
![]() |
![]() |