sybperl-l Archive

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-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-_
^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_-^-_--^