| Display own message [message #192981] |
Thu, 14 September 2006 08:14  |
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  |
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!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
