Re: Testing procedures using message boxes.

From: Eric C. Janzen <ejanzen_at_telusplanet.net>
Date: Wed, 08 Dec 1999 16:45:01 GMT
Message-ID: <hWv34.27077$n3.396530_at_news1.telusplanet.net>

Quick and easy?

message('The result is: '||v_return_value); pause;

This will show the message in the status bar.

Want pop-up windows?

I suggest you read up on alerts.

Basically:

1. Create a generic alert
2. When you have a message to display, set the alert message
3. Display the alert

DECLARE
   alert_id       ALERT := find_alert('generic_alert');

   v_dummy NUMBER;
   v_return_value NUMBER;
BEGIN
..
<your code here>
..

   set_alert_property(alert_id, ALERT_MESSAGE_TEXT,  'The result is: '||v_return_value);

• now show the alert v_dummy:= show_alert(alert_id);

...

END;

--
--------------------------------------------------
Eric Janzen
E. Janzen Consulting Inc.
Oracle Development Specialist
--------------------------------------------------


AdSum <bellagiornataNObeSPAM_at_netscape.net.invalid> wrote in message
news:0f5b83e7.0a5fe7f6_at_usw-ex0102-015.remarq.com...


> I'm new to Developer and working my way through a procedure.


>


> As I test it out, I need to be able to display variables or the results


> of built in functions (such as find_group or id_null) in a window,

> similar to the msgbox function or debug.print in MS Access.

>


> Does anyone know an easy way to accomplish this in Forms ?


>


> Thanks for any help.


>
>


> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network


*


> The fastest and easiest way to search and participate in Usenet - Free!


>

Received on Wed Dec 08 1999 - 17:45:01 CET