Re: Oracle Forms 3.0: Referencing Fields
From: Frank <frankbo_at_interaccess.nl>
Date: Thu, 5 Oct 2000 11:03:08 +0200
Message-ID: <8rhg4s$o0a$1_at_porthos.nl.uu.net>
Date: Thu, 5 Oct 2000 11:03:08 +0200
Message-ID: <8rhg4s$o0a$1_at_porthos.nl.uu.net>
[Quoted] So what you are saying is that the trigger fires, the code is executed, but the referenced fields are null?
-- Frank Dons <m.v.vandonselaar_at_donotspam.kpn.com> schreef in berichtnieuws k5emtsklh2bkqhe7q5nkfpdrl6v0ifgjda_at_4ax.com...Received on Thu Oct 05 2000 - 11:03:08 CEST
> On Tue, 3 Oct 2000 20:02:52 -0700, "Matt B."
> <mcb_at_fightspam.sd.znet.com> wrote:
>
> >"Dons" <m.v.vandonselaar_at_donotspam.kpn.com> wrote in message
> >news:en3ktsg288sv401g5g5rqqu41pnr4q5nch_at_4ax.com...
> >> Hi,
> >>
> >> I'm working on a forms30 form and I have problems referencing fields
> >> in PL/SQL. It seems sometimes referencing a field returns no value.
> >> This happens if I have called another form via CALL_QUERY and press
> >> the exit key so I return to the original form.
> >>
> >> Hopefully anyone can explain what's the problem
> >>
> >> Greetings,
> >>
> >> Martin
> >>
> >> PS. I Know I should quit using this old stuff, tell my boss ;-)
> >
> >How are you referencing the field? Can you give an example?
>
> Procedure set_visible_page is
> begin
> if name_in('b_hrk.soort_interface') = 'JP' then
> show_interf_data('6');
> elsif :b_hrk.soort_interface = 'FAC' then
> show_interf_data('7');
> elsif :b_hrk.soort_interface = 'AANVRAAG'
> OR :b_hrk.soort_interface = 'ONTV' then
> show_interf_data('8');
> elsif :b_hrk.soort_interface = 'PROJECT' then
> show_interf_data('9');
> else
> hide_interf_data;
> end if;
> end;
>
> Procedure show_interf_data (p_page IN varchar2) is
> begin
> if p_page <> 6 then
> hide_page(6);
> end if;
> if p_page <> 7 then
> hide_page(7);
> end if;
> if p_page <> 8 then
> hide_page(8);
> end if;
> if p_page <> 9 then
> hide_page(9);
> end if;
> show_page(p_page);
> end;
>
> Procedure hide_interf_data is
> begin
> hide_page(6);
> hide_page(7);
> hide_page(8);
> hide_page(9);
> end;
>
> As you can see I tried name_in als well as the 'normal' referencing.
> Both do not seem to work. I'm sure this procedure runs (at the rigth
> moment) because I tested this in debug mode. Normally it runs fine (It
> is called from a PRE_RECORD_TRIGGER and ON-VALIDATE-FIELD on
> b_hrk.soort_interface). However it does not if called from a
> on-new-field-instance or in the situation in my original post (even
> when the PRE_RECORD_TRIGGER fires). I'm out of options but I migth be
> missing the obvious? Maybe the problem is something else?
>
> Greetz,
>
> Martin
>