Home » Developer & Programmer » Forms » On-Error vs On-Message
On-Error vs On-Message [message #81902] Mon, 31 March 2003 06:55 Go to next message
Peter
Messages: 62
Registered: August 2000
Member
anybode knows the difference between an On-Error and onMessage triggers in forms ?

Thanks
Re: On-Error vs On-Message [message #81908 is a reply to message #81902] Mon, 31 March 2003 23:39 Go to previous message
utsav
Messages: 94
Registered: March 2003
Member
Hi,

These are the two triggers which are used to trap any erroors or messages that will be diaplyed.

Write these triggers on the form level, because if u have these triggers on form level and any level below it, form level will be executed.

Whenever there is an error of frm or ora type onerrors will be fired. To trap the error the err_code and err_text.

Whenever and message is displayes like, transaction complete or n records displayed, on message trigger wll be fired, use message_code and message_text to trap these.

U can also use message_level to suppress the messages as u like
In case of problems do let me know.

utsav.
Previous Topic: forms triggers
Next Topic: Report builder doesn't work correctly
Goto Forum:
  


Current Time: Thu Apr 25 08:01:21 CDT 2024