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: Jonathan Ham <jonathan at mementech dot com>
Subject: Re: Can't get rid of "pending results"
Date: Nov 1 1997 1:22AM

> DB-Library error:
>         Attempt to initiate a new SQL Server operation with results pending.

> $dbHandle->dbcmdn($select4);
> $dbHandle->dbsqlexec;
> $dbHandle->dbresults;
> while (@data = $dbHandle->dbnextrow) { print "."; };
> $dbHandle->dbcmdn($select5);
> $dbHandle->dbsqlexec;
> $dbHandle->dbresults;
> while (@data = $dbHandle->dbnextrow) { };


Maybe...

$dbHandle->dbcmdn($select4);
$dbHandle->dbsqlexec;
$dbHandle->dbresults;
while (@data = $dbHandle->dbnextrow) { print "."; };
$newHandle = Sybase::DBlib->dbopen();	## Perhaps by opening a new
$newHandle->dbcmdn($select5);		## connection, you won't
$newHandle->dbsqlexec;			## be caught waiting for
$newHandle->dbresults;			## the first one to process.
while (@data = $newHandle->dbnextrow) { };


I don't know if this solves it -- just a guess.


/jonathan

_-Jonathan Ham^-_-^-_-^-_-^-_-^-_ideas have C O N S E Q U E N C E S-_
^-Systems Engineer_-^-_-^-_-^-_-^-_--^
_-mementech-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-_
^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_--^