|
|
|
|
|
|
|
Re: System.message_level Equivalent in Reports [message #260865 is a reply to message #260810] |
Tue, 21 August 2007 02:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Well, how about NOT aborting the report? Is it really necessary? Would something like this be OK?EXCEPTION
WHEN NO_DATA_FOUND THEN
SRW.MESSAGE(1000,'THE AGENT CODE THAT YOU SELECTED CONTAINS NON DOLLAR VALUES'); This would show a message, but report would be created.
On the other hand, message text ('The agent code that you selected contains non dollar values') suggests that 'agent code' is selected from a list of values. So, why wouldn't you restrict values returned by LoV query. Something likeSELECT agent_code
FROM this_table
WHERE currency_values = 'DOLLAR' This would make it impossible to choose unwanted values, Formula column query wouldn't return NO-DATA-FOUND and you wouldn't have to worry about program abortion.
|
|
|