Home » Developer & Programmer » Reports & Discoverer » result of the query (reports6i) from the forms6i
result of the query (reports6i) from the forms6i [message #88561] Mon, 18 November 2002 03:55 Go to next message
Rajinikanth
Messages: 4
Registered: July 2002
Junior Member
I want to find the result of the query (query status)
that is in reports6i when called from forms6i
eg:
i have select * from dual in a report
when i call this report from forms6i i just want to know whether this query returned any records.

Report message to a moderator

Re: result of the query (reports6i) from the forms6i [message #88577 is a reply to message #88561] Fri, 22 November 2002 03:20 Go to previous message
Neeraj Kumar
Messages: 9
Registered: November 2002
Junior Member
There are two ways to know this. Either u can use SRW utility for which u can ger help in report builder or you can use Exception
i.e
Begin
Select tname into x from dual;
Exception
When no data found then
SRW.message(1,'No Recors found');
End;

Report message to a moderator

Previous Topic: setting a Page Break
Next Topic: Weighted Average in Discoverer -Urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 07:23:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.