system
April 2, 2008, 9:01pm
#1
Hi,
Is there anyway I can avoid this popup screen that says “There is no data corresponding to this query” when there is no data to return.
Is there anyway to achieve someway like including dummy table in the query and returning some dummy value. (Say table from dual in oracle).
We are on DB2. What would be the table in this case?
Thanks
Taurean
Taurean (BOB member since 2005-08-15)
system
April 3, 2008, 5:21am
#2
Hi- we did this in my project by adding a union to a query from dual table. Im not sure what you can do for sybase- perhaps if theres no such table you may need to create a dummy table which is just for this purpose. There are other ways as well to handle the supressing of popups.
Check this post for ideas
How can I supress the ‘No Data To Fetch’ message?
There are multiple methods of supressing the ‘No Data To Fetch’ message.
Programmatically…
If you copy this code into the ThisDocument module, it should work. To implement the code, you will need to have your Report which gives you the No Data to fetch message open. Click on Alt + F11, and the Visual Basic Editor will open. On the left hand side you should see a list of all the documents you have open. Under the name of the documen…
Roshknee (BOB member since 2007-10-29)
system
April 4, 2008, 6:27pm
#3
Thanks for sending me the link. I got the dummytable name. It is sysdummy1.
Taurean
Taurean (BOB member since 2005-08-15)