OraFAQ Forum: Forms » ***Contditional EXIT before running Report***

Home » Developer & Programmer » Forms » ***Contditional EXIT before running Report***

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

***Contditional EXIT before running Report*** [message #80267]

Sat, 31 August 2002 19:40

Robin
Messages: 73
Registered: October 2001

Member

Xperts,
In After_parameter_form trigger in report I want to write code like this-
if ( user='Robin' ) then
Exit report /* problem, compilation error*/
end if;

Pls give me a solusion.
Thanks
Robin

Report message to a moderator

Re: ***Contditional EXIT before running Report*** [message #80271 is a reply to message #80267]

Sun, 01 September 2002 11:03

Julie Toft
Messages: 9
Registered: August 2002

Junior Member

Use SRW.PROGRAM_ABORT

IF v_user = 'Robin' THEN
srw.message(100, 'User is Robin - Exiting');
raise srw.program_abort;
END IF;

Report message to a moderator

Re: ***Thank u JULIE*** [message #80300 is a reply to message #80267]

Wed, 04 September 2002 21:41

Robin
Messages: 73
Registered: October 2001

Member

Thanks.

Report message to a moderator

Previous Topic:	Email from forms
Next Topic:	why constraints

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 00:34:11 CDT 2024