Xref: alice comp.databases.oracle.tools:29282
Path: alice!news-feed.fnsi.net!enews.sgi.com!newsfeed.mathworks.com!news-europe.mathworks.com!newsfeed.tli.de!news.algonet.se!algonet!newsfeed.icl.net!newspeer.clara.net!news.clara.net!remarQ-uK!remarQ.com!supernews.com!tank.news.pipex.net!pipex!uunet!zur.uu.net!ffx.uu.net!news1.optus.net.au!optus!platinum.sge.net!newshost.sge.net!news.dpie.gov.au!not-for-mail
From: "Suzanne Edgecombe" <Suzanne.Edgecombe@agso.gov.au>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Supress Built In Messages
Date: Tue, 27 Jul 1999 13:04:01 +1000
Organization: Australian Commonwealth Department of Agriculture, Fisheries and Forests http://www.daff.gov.au/
Lines: 53
Message-ID: <7nj7ia$su33@thredbo.dpie.gov.au>
References: <379CBFA0.6AC3514A@crha-health.ab.ca>
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

Hi Shelli,

You can do a search on the FRM number in the online help and it will tell
you the "severity" of the message.  Some messages can be suppressed, others
(with a severity of >25) cannot. I think the FRM message that you are
getting is number FRM-40401, or FRM-40405, which both have a low severity
value of 5, s these can be suppressed using the system.message_level built
in.....

I would suggest that you try the following in your code behind your
button....

declare
...
   oldmsg  varchar2(2);

begin

  oldmsg := :system.message_level;  - - this retains your original message
level setting, any messages with levels above this will be displayed.
  :system.message_level := 10;  - - reset the level to higher than the
messages that you want to suppress, in your case 5

 ...run your update statement here, and commit

:system.message_level := oldmsg;  - - reset to the original level, so that
you can catch any further messages.....

end;

let me know if this does not do the trick....

cheers

Sue Edgecombe




Shelli D. Orton wrote in message <379CBFA0.6AC3514A@crha-health.ab.ca>...
>Is there a way to supress a built message on an Oracle form?  I have a
>form that uses an update statement in a program unit to make changes to
>the database.  I have to do this because the information on the form is
>from multiple tables (it is not a master/detail form).  I have a button
>that says "Save" and executes the update statement and life is good.
>Except that I get a FRM message that says "No changes to save".  This is
>misleading to the user and I would like it supressed.
>
>Thanks for any help,
>Shelli
>