suppressing "no data to fetch"

system · November 29, 2002, 2:07am

How to suppress the BO Error messages. For example how to suppress “no data to fetch”

nwice (BOB member since 2002-11-20)

system · November 29, 2002, 3:10am

The only way is with VBA. You can supress those messages while the script runs. Otherwise, there is no way to do that.

MichaelWelter (BOB member since 2002-08-08)

system · November 29, 2002, 3:47am

I tried checking the no of rows returned from data providers, in after refresh event, even then it’s not working…

nwice (BOB member since 2002-11-20)

system · November 29, 2002, 2:47pm

If you use the following URL, this may provide you with a solution to your problem.

Thanks

Roller

Roller (BOB member since 2002-10-23)

system · November 30, 2002, 1:06am

That’s a great tip; I’ve used that technique before. However, it doesn’t supress the “No data to fetch” message. You can only do that through VBA. The VBA line to supress the messages is as follows:

Application.Interactive = False

MichaelWelter (BOB member since 2002-08-08)

system · November 30, 2002, 6:22pm

Hi,

Thanks for the tip, but unfortunately it won’t be useful because I have set of prompts in my report which will take user input…

nwice

nwice (BOB member since 2002-11-20)

system · November 30, 2002, 6:28pm

Hi Roller,

Really, it’s a great tip but unfortately I could’t stop the lousy message…

nwice (BOB member since 2002-11-20)

system · December 2, 2002, 2:51pm

Did you try a search? We’ve discussed this in the past. I found this from the loaded archives.

Cindy Clayton (BOB member since 2002-06-11)