PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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"
 > error?

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
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com