Re: Forms 5: get_block_property and debugging question

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 12 Dec 2002 10:31:13 +0100
Message-ID: <at9l2m$11ckbd$1_at_ID-152732.news.dfncis.de>


Hi Scotty (if I may say so ...)

P_MyMessage is a PU that is referenced from a pll library, which is attached to most of our Forms
(that is, in Forms 5: it is attached to a Reference Form only, and that form is the reference for the other Forms -
this kind of referencing has been changed in 6i).

Inside the pll, the code for is quite simple:

PROCEDURE p_MyMessage (MyMessages IN VARCHAR2)

   IS

   v_dummy Number;

BEGIN    Set_Alert_Property('AL_HINWEIS', ALERT_MESSAGE_TEXT, MyMessages);    v_dummy := Show_Alert('AL_HINWEIS');
-- MESSAGE (MyMessages);

END; I do not know all the implications of our pll, because we inherited it from the former developers,
bur so far we could work with it for years without having problems.

But after all, this was not my problem to bedug get_block_property( ). It was an ON-ERROR trigger on a too high level suppressing my messages. After changing that, I could see what was going wrong: it was the default_where property not being set as it should be ...

ThanX to all Your kind responses,

Jan=)

"Scott Mattes" <Scott_at_TheMattesFamily.ws> schrieb im Newsbeitrag news:g5HJ9.16826$VA5.1483613_at_news1.news.adelphia.net...
> I took the route, in Forms 6i, to create a text file with all the data I
> could about the form and its blocks and then put up, via message, a simple
> msg telling the user to contact the help desk.
>
> How are you putting up your message in "P_MyMessage"?
>
>
> "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
> news:at6sh5$10qioj$1_at_ID-152732.news.dfncis.de...
> > Hi, Carsten !
> >
> > Danke für den Tip, das hat mich etwas weiter gebracht ... wir hatten
einen
> > ON-ERROR-Trigger auf Form-Ebene,
> > um nur noch bestimmte Fehlermeldungen (für die DAUs) durchzulassen - den
> muß
> > man zum Debuggen solange auf irgendein Item-Level ziehen,
> > um die Codes zu sehen ... und jetz kommt auch die Meldung von
> > get_block_property richtig.
> >
> > ***
> > For the English speaking readers:
> > Thank You for the Tip, that leads a little further ... we had an
> > ON-ERROR-Trigger on Form level,
> > in order to cut all error messages (for the normal users out there)
except
> a
> > few - to debug, this trigger must be drawn to an item level
> > to see the error codes ... and now I see my message from
> get_block_property
> > correctly.
> >
> > Jan=)
> >
> >
> >
> > "Crypti" <ninjadesign_at_gmx.de> schrieb im Newsbeitrag
> > news:c5df9e15.0212100703.44475b8e_at_posting.google.com...
> > > "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
> > news:<at4j76$107jd5$1_at_ID-152732.news.dfncis.de>...
> > > > Hello,
> > > >
> > > > I want to debug a blocks´ DEFAULT_WHERE by using get_block_property
> > > > built_in.
> > > > My problems to do so are commented inside:
> > > >
> > > > PROCEDURE pu_where IS
> > > >
> > > > v_showme VarChar2(200) := '';
> > > >
> > > > BEGIN
> > > >
> > > > v_Showme := get_block_property('V_PERSON_SUCHEN',DEFAULT_WHERE);
> > > > P_MyMessage(v_Showme); --our own function for popping up
messages -
> > > > successfully used a million times ...
> > > > --does not come up at all ...
> > > >
> > > > v_Showme := 'in the case that nothing comes up ...';
> > > > P_MyMessage(v_Showme);
> > > > --does not come up either ... only if I delete the above
> > get_block_property
> > > >
> > > > ... a bunch of other tasks, especially block property settings ...
> > > >
> > > > v_Showme := 'I´m ready';
> > > > P_MyMessage(v_Showme);
> > > > --does not come up either ... only if I delete the above
> > get_block_property
> > > >
> > > > END;
> > > >
> > > > ... this is another moment when Forms (5.0) drive me crazy ...
> > > >
> > > > Any comments are greatfully appreciated.
> > > >
> > > > Jan
> > >
> > > Scheint so, als ob die get_block_property schief geht. Vielleicht ist
> > > ja der Blockname inkorrekt und das ERROR_LEVEL zu hoch eingestellt?
> > > Wenn die erste Zeile auskommentiert ist, und die P_MyMessage-Funktion
> > > ausgeführt wird, (beispielsweise mit 'LALA'||v_ShowMe) funktioniert
> > > das?
> > >
> > > Tschau,
> > > Carsten
> >
> >
>
>
Received on Thu Dec 12 2002 - 10:31:13 CET

Original text of this message