Re: do_key('exit_form')

From: Brian Neary <bneary_at_gnosis-is.com>
Date: Fri, 11 Feb 2000 08:00:32 -0800
Message-ID: <3tWo4.20$Qo2.182798_at_news.bctel.net>

You can override messages in the form level ON-MESSAGE trigger.

The following is an example from the help.

DECLARE
  alert_button NUMBER;

  lv_errtype VARCHAR2(3) := MESSAGE_TYPE;
  lv_errcod NUMBER := MESSAGE_CODE;
  lv_errtxt VARCHAR2(80) := MESSAGE_TEXT;

BEGIN
  IF lv_errcod = 40350 THEN
    alert_button := Show_Alert('continue_alert');     IF alert_button = ALERT_BUTTON1 THEN       ...
    ELSE
      ...
    END IF;
  ELSE
    Message(lv_errtyp||'-'||to_char(lv_errcod)||': '||lv_errtxt);     RAISE Form_Trigger_Failure;
  END IF;
END; [Quoted] Brian West wrote in message <38A04D19.C5F834E0_at_indosoft.nb.ca>...
>I am trying to override the default alert that oracle provides when
>unsaved changes exist and you try to exit the form. I would like my
>alert to be 'Unsaved Changes exist? Do you wish to save them?'
>YES -- No -- CANCEL ---> If 'yes' is clicked, a validation routine
>is run. If 'cancel' is clicked, you return to the form. These work fine.
>The problem is that when 'no' is clicked, I want to exit the form
>(full_rollback, no_commit), but the default oracle message appears
>following. Does anyoneknow how to suppress this? This functionality is
>currently inside the form level do_key(exit_form) trigger.
>
>Thanks
>
Received on Fri Feb 11 2000 - 17:00:32 CET