Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: gbu at uhc dot com (Gary Udstrand)
Subject: Re: results pending error
Date: May 6 1998 6:40PM

	The drop table call is made in a sequence, I complete each sub call
prior to calling another (no nesting problems with the reuse of the

On Wed, 6 May 1998 13:41:25 -0400, you wrote:

>are you doing something like:
>dbcmd($dbproc, "SELECT table FROM tables");
>while (@ret = &dbnextrow($dbproc)) {
>     &drop_table($dbproc, @ret[0]);
>if you are the problem is that your first dbproc is already ties up in the
>SELECT and can't be used at this time.
>open up a new dbproc in your drop_table sub.
>I also hope there is a good reason you are still using perl 4.

Gary Udstrand 
The opinions expressed are mine only, unless you agree with me.

The world is filled with willing people; some willing to work, the rest 
willing to let them. 
							-Robert Frost