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?
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 - 03:20:42 CDT