Home » Developer & Programmer » Forms » Display own message
Display own message [message #192981] Thu, 14 September 2006 08:14 Go to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi,
When I open my form, I get values from a webservice. If there are no values returned, I am getting an error message
FRM-40350: Query caused no records to be retrieved
Instead of this message, I want to display my own message .
I tried out something like this.

In On-error trigger at form level,

if error_code=40350 then
message('There are no tasks!!');
message('There are no tasks!!');
end if;
My message is not getting displayed.
I actually want to direct to another canvas and display this message.
How can I achieve this task?
Re: Display own message [message #192989 is a reply to message #192981] Thu, 14 September 2006 08:57 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
TRY On-Message trigger at form level,

 if message_code=40350 then
      message('There are no tasks!!');
      message(' ');
 else
      message(Message_code||': '||Message_text);
 end if;


Your message will be shown on an alert!
Re: Display own message [message #193213 is a reply to message #192989] Fri, 15 September 2006 05:37 Go to previous message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Thank you friend!! It works!!
Previous Topic: Report doesn't display (web)
Next Topic: have to open a browser from a button
Goto Forum:
  


Current Time: Thu Dec 08 00:14:11 CST 2016

Total time taken to generate the page: 0.13493 seconds