Up Prev Next
From: Michael Peppler <mpeppler at mbay dot net>
Subject: != NO_MORE_RESULTS vs. == SUCCEED (was Re: sp_spaceused in sybperl)
Date: Sep 10 1998 4:56PM
David C Worenklein writes:
> If dbresults returns FAIL (eg network error), you won't catch that
> with a != NO_MORE_RESULTS loop.
> I wonder, though, if you have 6 results sets, and the network craps
> out on the 3rd and then comes back, will you get a "results pending"
Actually, you will normally catch the error.
If dbresults() returns FAIL, then you should call it once more and it
will return NO_MORE_RESULTS, which will let you exit the loop.
At least that's the way I've always coded things, and it's the way
it's worked for me in the past.
I could of course be wrong :-)
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com