Home » Developer & Programmer » Reports & Discoverer » Displaying an Error Message
icon4.gif  Displaying an Error Message [message #262070] Fri, 24 August 2007 07:44 Go to next message
nishasundar
Messages: 4
Registered: August 2007
Junior Member
Hai all,
In report if i enter any parameter value(in text box) that does not match any records,i should get an error message like,
"Invalid Customer Name...." and also kindly tell me how to stop the generation of report once the error message displays.

Thanks & Regards,
S.Nisha
Re: Displaying an Error Message [message #262075 is a reply to message #262070] Fri, 24 August 2007 07:55 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Validate parameter's value in the AFTER PARAMETER FORM trigger.
Raise an error using the SRW.PROGRAM_ABORT built-in.
Re: Displaying an Error Message [message #262200 is a reply to message #262075] Sat, 25 August 2007 01:11 Go to previous messageGo to next message
nishasundar
Messages: 4
Registered: August 2007
Junior Member
Hai,
Thank you for your reply.Can you please give me some examples for validate parameter's value in the AFTER PARAMETER FORM trigger.

Thanks & Regards,
S.Nisha
Re: Displaying an Error Message [message #262262 is a reply to message #262070] Sat, 25 August 2007 13:31 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
nishasundar
If i enter any parameter value (in text box) that does not match any records,i should get an error message

How would YOU validate parameter's value? Use pure (PL/)SQL (forget about triggers), or you can write a pseudo-code if you wish. Just don't open your mouth and say "Feed me! Feed me!".
Previous Topic: Setting the Default Page Size for printing (Oracle Reports 10g) (merged by LF)
Next Topic: Problem in formatting report in arabic and english
Goto Forum:
  


Current Time: Sat Dec 14 16:46:01 CST 2024